Lot Detail Account Mismatch¶
Adjustments are used to transfer product between accounts. If the account identifier on an adjustment is not the recipient for the transfer, then lots created by the adjustment will be assigned to the wrong account. Use these instructions to correct the account on lots.
Preliminary Requirements¶
Before this correction is run the first time, two entries must be added to WARES design to identify incorrect lot accounts.
Dictionary LOT_ACCOUNT¶
At menu selection Tools ‣ Reports ‣ Dictionary, add an
entry for the DETAILS
table, column PROD_ACCOUNT
, as shown in
the following screenshot:
Tip
The code expansion is shown by pressing <F3>
. Use <F9>
to save
and <Esc>
to exit the expanded view, then save the dictionary record
by pressing <F9>
again.
Report DETAIL.PROD-ACCT¶
At menu selection Tools ‣ Processes ‣ Report Setup, add a
new report DETAIL.PROD-ACCT
as shown in the following screenshot:
Correcting Lot Accounts¶
There are two simple steps to correct account mismatches on lots.
Report Lot Account Mismatches¶
Run report Reports ‣ Miscellaneous ‣ DETAIL.PROD-ACCT, viewing the output. If and only if lots are displayed on the report, escape from the report viewer and proceed directly to the next step.
Fix Lot Account Mismatches¶
Warning
The COPYCOL utility can make irreversible changes to your data system. Do not use this utility without technical support unless you are absolutely certain about what you are doing.
From menu selection Tools ‣ General ‣ Copy Columns, enter the following command information:
File Name | DETAILS |
Source Data | PROD_ACCOUNT |
To Field | ACCOUNT |
Press <F9>
to continue to the Browse Selections list, and
select (press <Enter>
) Query Table. If the top line of
the Stored Query Table says SELECT DETAILS WITHOUT ACCOUNT EQ
PROD_ACCOUNT ... and has the correct number of hits, then press <Enter>
,
otherwise press <Esc>
and start over.
Finally, you should see the Copy Columns confirmation message. it must read:
Using File: | DETAILS |
From Field = | PROD_ACCOUNT |
To column = | ACCOUNT |
Match Value = |
If everything is correct, enter Y <Enter>
to change the lot account.