Inventory Management

OK, I think jjmmss1 wants to know how to import a phys. inventory journal from a text file created by a barcode device.

I solved it the following way:

- change the function in Functions/Calculate Inventory to make Qty. (Physical Inventory) initially zero.

- write a dataport for the textfile. If there is a line containing the same item /variant with the same bin, increase the quantity (phys. inventory)
- if not, create a new line
- always check whether the new qty. ( phys. inventory) will be higher than qty. (calculated), if yes, set Gen. Bus. Posting Group to INV_SURPLUS, if not, to INV_MISSING in order to make G/L postings right: surplus posts to a revenue, missing inventory posts to a cost account
- set up general posting setup that the Inventory Adjustment Account of INV_SURPLUS points to a revenue account and that of INV_MISSIGN points to a cost account

I think jjmmss1 wants us to do his work for him

jjmmss1 wrote:

what is cal code for posting a result into the physical inventory journal?

What do you want to do with the C/AL code ? do you want to make a modification or do you face problem to run it..??



Rgds,