Oki. Master data in our company. // we have Items with “Unit Cost” on ‘Item Card’ and etc.. [Item ‘80216-T’, Unit Cost = 0.50]
Set Company \ Display Name.
Setup yourself as ‘Warehouse Employee’.
Create new ‘Item Tracking Code’ (LOTALLWMS).
Set Item (‘80216-T’) \\ Item Tracking Code = LOTALLWMS.
Well, now find Whse. Phys. Invt. Journal and fill a dummy line (do not register this ‘Journal’).
// I think good idea do not produce posted data directly… better fill ‘Journal’ and Post/Register ‘Journal’ manually…
You see ‘Warehouse Physical Inventory Journal’ does not have “Lot No.” and “Expiration Date” columns.
We no need it for our example because we fill data via Excel. BUT you can add “Lot No.” via Personalise.
For “Expiration Date” you need create an extension. // for an extension remove dependencies
Let’s start play with Configuration Package.
// Clear Included for all lines (System save Primary Key fields in any case)
Set ‘Include Field’ for necessary fields.
// “Validate Field” = no for “From Bin Code”
As result:
------------------
At this point not so bad idea use Validate Package action.
// Configuration Package is for admins. You should be carefully with this tool.
------------------
Export to Excel our Dummy line.
Modify Excel file. // add new lines and etc..
Delete our Dummy line. // ‘Warehouse Physical Inventory Journal’
Import from Excel and Apply Package.
------------------
At this point not so bad idea use Validate Package action.
// Configuration Package is for admins. You should be carefully with this tool.
------------------
Register ‘Warehouse Physical Inventory Journal’.
Go to ‘Item Journal’ and run ‘Calculate Warehouse Adjustment’.
Post ‘Item Journal’.
Check ‘Item Tracking Entries’.
Run ‘Post Inventory Cost to G/L’.
Check ‘Chart Accounts’.
Save our package.
1,659
Share
Report
All responses (
Answers (
