195
What is the Table ID in Configuration Package to import Apply Vendor Entries/Apply Customer Entries? I try to dig the whole Table ID list, doesn't seem any of the ID match this 2 screens, or did I missed it. The nearest I can find is " 1294 - Applied Payment Entry", but it is not referring to the table I want.
I need to migrate a list of Vendor/Customer paid invoices with payments to BC, and I have the list of apply data together.
Steve,
I am trying to do this same process and we are getting the apply in the table, but it is not showing applied. It appears that we need to still set the Apply Id. Have you done this and any idea what I might be missing?
Thanks in advance,
Tanya
Noted on that. Thanks for the feedback Steve.
Regards,
Kelvin Hew
Kelvin,
I have not used any other method though I follow what you are saying. Depending on the customer and how many payments we were talking about, I sometimes recommended that we bring the payment in unassigned, and they use base BC on the Customer Ledger Entries and Apply Entries. It was a great training tool for users.
Thanks,
Steve
Hi Steve,
The suggested method works if the invoice and payment document is 1 to 1.
If 1 of the payment document is applying to 4 invoices, then I will need to import 4 payment lines in payment journal screen using same payment Document Number.
Is there any other method that allows me to import as 1 payment lines in payment journal screen but still able to apply to 4 invoices?
Thanks,
Kelvin Hew
Kelvin,
If you are loading Vendor and Customer payments and want to apply them, hitting Table 81 noting the correct Journal Template Name and Batch Name (Payment Journal and Cash Receipt Journal) then Document Type = Payment, you can fill in the required fields and also Applies-to Document Type and Applies-to Document No. The field will validate and create the application when posted.
Hope this helps.
Thanks,
Steve
#1
YUN ZHU
413
Super User 2025 Season 1
#2
Sagar Dangar, MCP
274
#3
Mansi Soni
247
Share
Report
All responses (
Answers (
