Hello, The problem I have is that I have two data items as follows Sales Invoice Line Value Entry Item Ledger Entry The purpose of this excercise is to add the serial numbers to the invoice report. The problem is that because of the data item order the serial number is always listed one line beneath the item it belongs to on invoice. Is there anyway I can align them even though they are at different levels so that I get Description S/N Digital Watch 1234 Instead of Digital Watch 1234 Thanks
I guess you have linked the Item Ledger entry dataitem to Sales Invoice Line to get the Serial No. from the Item Ledger Entry?!? Try this: In Sales Invoice Line DataItem create variables for ValueEntry and ItemLedgEntry (this one has to be a global variable). Find the appropriate ItemLedgEntry. In the Sales Invoice LIne Body-section make a textbox with source expression ItemLedgEntry.“Serial No.”. Don’t forget to CLEAR the ItemLedgEntry variable in case you do not find an Item Ledger Entry for a certaion Sales invoice Line (i.e. type is not Item). Otherwise you will see the Serial No. from the previously found Item Ledger Entry. And remember: the Value Entry is only connected by Document No. to the Sales invoice Line. In combination with Item No. you might be able to find the right one, but only, if each Item No. only exists once per Sales Invoice.
You could just move the textboxes to the Item Ledger Entry section, so that they’re all on one line. The only small catch is that if you move the Description textbox, say, from the Sales Invoice Line section, you should also change its SourceExpr to “Sales Invoice Line”.Description; otherwise, the report will display the Item Ledger Entry’s description. Alastair
quote:
Originally posted by chucky Description S/N Digital Watch 1234 Instead of Digital Watch 1234
Are you sure? - you’ll have a lot of item description when you sell more that 1 pcs. Tõnu