Hi everyone,
Can anyone give me some suggestions on how to capture the data from other document type such as from other page ID?
My condition now is ^Source Name column in Item Ledger Entries are captured directly from the Customer Card/Vendor card. But now my problem is how can I change the data from customer card/vendor card to other document type such as (capture the data (Sell-to customer name) Column from Sales Return Receipt? Remark: the Sales Return Receipt is from other page ID. I want to based on below page ID to captured the data.(Picture 1) to replace the data in the Customer/vendor card
See the picture below for reference:
Picture 1: Document type that want to replace the customer card/vendor card's data
Picture 2: Expected outcome that I wish to have
The picture 2 is the expected outcome, which already change the customer/vendor card to other document type which I had screenshot above.
Here is the original code i have:
The source type is all based on customer and vendor. But I don't know how to capture the data from other document type in order to replace the data from the customer/vendor card.
Can anyone guide me on the above issues?
Thanks.
Hi,
I just want to make double confirm about the below document type, and I want to capture the data which is Order No.
Purchase Return Shipment : Check Document Type is "Purchase Return Shipment" and then Get from table Purchase Return Shipment , linked by Document No.
Purchase Receipt : Check Document Type is "Purchase Receipt" and then Get from table Purch. Rcpt. Header, linked by Document No
Sales Shipment : Check Document Type is "Sales Shipment" and then Get from table Sales Shipment Header, linked by Document No
Sales Return Receipt : Check Document Type is "Sales Return Receipt" and then Get from table Return Receipt Header, linked by Document No
But I have faced one issue which is is it the order no is same as return order no? Since for Purchase Return Receipt and Sales Return Receipt, I cannot find Order No in the table, only have Return Order No
Hope anyone can help me about this.
Many Thanks Here.
Yes , also by Document No.
Hi,
Thanks for reply.
I had solve the above document types as mentioned above.
Between one more question, is it Purchase invoice, Purchase Receipt and Purchase Credit Memo also linked by document No??
Thanks.
Sales Credit Memo : Check Document Type is "Sales Credit Memo" and then Get from table Sales Cr.Memo Header , linked by Document No.
Sales Invoice : Check Document Type is "Sales Invoice" and then Get from table Sales Invoice Header , linked by Document No.
Sales Return Receipt : Check Document Type is "Sales Return Receipt" and then Get from table Return Receipt Header , linked by Document No.
Sales Shipment : Check Document Type is "Sales Shipment" and then Get from table Sales Shipment Header , linked by Document No.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,522 Super User 2024 Season 2
Martin Dráb 228,441 Most Valuable Professional
nmaenpaa 101,148