Question

How to Update the Pay By Line (AP or AR) using a Business Event.

  • 2 January 2024
  • 5 replies
  • 53 views
Michaelh
Rank
Userlevel 5
Badge

I have an inquiry that shows all Bills who need to have the Pay by Line box checked (next I am doing Invoices and Memos). I have a business event that triggers off an import scenario every time a new qualifying record is created.

 

Below is my import, it shows that it runs successfully in the event history, but the PAY BY LINE box is never checked like I need. Anyone know what I may be missing???

 


I have tried setting the checkbox value to:

=’1’

=1

=’True’

=True

 

Nothing seems to stick. The history says it accessed the proper document, but nothing is ever changed. Thanks for the help!

Permanent Newb, don't let the posts fool you.

5 replies

Laura02
Rank
Badge +18

Hello,

Is Pay by Line selected ON in the Default Payment Settings section of Payment tab on the Vendor profiles on the bills that are being imported?

Laura

Laura ~ Klear Systems, Inc. Irvine, CA. ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~
Michaelh
Rank
Userlevel 5
Badge

Yes it is, I can MANUALLY select the PAY BY LINE button and save without issue or pop-up windows. 

Permanent Newb, don't let the posts fool you.
Laura02
Rank
Badge +18

If the vendor is checked ON for Pay by Line, all their AP Bills should default themselves to Pay by Line being checked ON.  I’m thinking you shouldn’t have to import the field at all.

When you manually add a bill for the same vendor, is Pay by Line defaulting ON? If not, do you have any customizations?  If you have customizations, do you see the same default Pay by Line behavior with customizations temporarily unpublished?

What is your version of Acumatica?

Edited to add one more thought - Are you trying to update bills that are already Open status?

Laura

 

 

Laura ~ Klear Systems, Inc. Irvine, CA. ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~
Michaelh
Rank
Userlevel 5
Badge

Acumatica 2023 R1
Build 23.113.0042

These are coming from Bills who were checked (but an employee unchecked the box on the form) and also from Submitted Expense Reports, where the employee is checked for PAY BY LINE, but the expense claims come across as unchecked. In either case, my inquiry shows them when they get made, then I’m HOPING to get an import to check the PAY BY LINE box.

Permanent Newb, don't let the posts fool you.
Chris Hackett
Rank
Userlevel 7
Badge

Hi @Michael Hansen were you able to find a solution? Thank you!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved