Item Journal Line Posting

lloydsmods · 2009-10-07

I have an odd question. I have written a custom mod that replenishes a customer's retail stores based on average sales. The function calculates a required quantity per item, per store (location) and writes the results to Item Journal Lines as transfers from the warehouse to the stores and then posts them. My customer is concerned about something he found in the data from a recent transfer. My code created a required amount of nine (9) for a particular store. NAV posted this as two item ledger entries, one for four (4) units and another for five (5). :shock:

I don't know if this is a problem, but my persnickety customer thinks it is. I explained that it has to be how NAV posts the journal lines, since my code would not calculate this split. My customer insists that there must be something wrong with my code and if not, he wants to know why NAV does this. :-k

Any ideas?

ara3n · 2009-10-07

To prove to your customer that your code works fine.

Open the reclass journal enter the item no, quantity, and old location/new location field

Post the transaction. It should create the two entries.

lloydsmods · 2009-10-08

I can see in the item ledger that they have done this themselves. For example, they transferred 12 units from the warehouse to a store and the item ledger shows FOUR entries. 12 from the warehouse and then the 12 move to the stores in three entries of 8, 2, and 2. The customer's complaint is "if it's not your code, don't you want to know why it works this way?" I dont have an answer that satisfies them other than "that's the way NAV does it". So the question remains, why does NAV do it that way?

ara3n · 2009-10-08

The reason is costing. In order for transfer entries to have zero effect if you have item level costing, the transfer entries need to have equal cost amount.

Item Journal Line Posting

Comments

Categories