[brandon@alterecofoods.com]

Greetings NS UserGroup, this is my first post here. In the recent weeks I have been familiarizing myself with the reporting capabilities of NS and have one dying urge which I need help to actualize.

I have customized a version of Inventory Valuation to report the transaction history of each lot code(of its parent item/product code) and to summarize at the bottom the remaining qty on hand.This is great, I am really close to what I need… as long as each transaction only has one lot fulfilled for each line item. The problem is that if a transaction has been fulfilled with multiple lots under one line item it displays in the report as a whole new section and list all lot codes from that transaction rather then each lot code separating out and being reporting nice and neat.

I realize this explanation is “clear as mud” and hope that the attached PDF will clarify. The first few lots (27705, 26401, 27706) show how I would like the report to look consistently… and the last lot(26401(5),27706(11)) shows the problem area whereby two lots are being reported in one section of the report(effectively as one lot). I would like the two lots which were fulfilled from this transaction to appear as normal lines up above under their respective lots, 26401 and 27706.

Secondly, I would like to introduce a “before” balance so that I can see, using the date filters, what the running balance is for each lot and then the transactions and then the total aka qty on hand.

Thanks for reading!
This is a cached copy. Click here to see the original post.

[brandon@alterecofoods.com]

I am not sure if the attachment went through, second attempt. ??? Okay, I don’t seem to have permission to upload files.

[Author]

Posts