Skip to main content
Solved

Import Scenario - AR Payments and Applications SO Payments

  • September 5, 2023
  • 3 replies
  • 300 views

Forum|alt.badge.img
  • Varsity I
  • 20 replies

Hey everyone, 

I’m having a difficult time with this one. I broke my brain over it over the holiday weekend. I had this working at some point at the beginning of the project last week and I must have accidentally unclicked something and I can’t figure out what. 

I’m bringing in Payments for Sales Orders, so I have an import scenario to add a prepayment and then load the sales order. I keep getting this “Missing operator before the Order operand.” issue. 

Any tips from anyone out there? I’m stumped. 

Best answer by gusl

@manikantad18 I got this figured out. The error “Missing operator before the Order operand” error was related to missing a single quote for a formula. Hopefully this helps someone in the future. See below for the example:

With Error: ='Manual Payment Import - KAI' + ' ' + Shopify Order+ ' ' + [Name]

Fixed:        ='Manual Payment Import - KAI' + ' ' + 'Shopify Order'+ ' ' + [Name]

View original
Did this topic help you find an answer to your question?

3 replies

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13

Hi @gusl 

Please share the XML report of Import scenario for quick review.

Thanks


Forum|alt.badge.img
  • Author
  • Varsity I
  • 20 replies
  • Answer
  • September 5, 2023

@manikantad18 I got this figured out. The error “Missing operator before the Order operand” error was related to missing a single quote for a formula. Hopefully this helps someone in the future. See below for the example:

With Error: ='Manual Payment Import - KAI' + ' ' + Shopify Order+ ' ' + [Name]

Fixed:        ='Manual Payment Import - KAI' + ' ' + 'Shopify Order'+ ' ' + [Name]


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2729 replies
  • September 7, 2023

Thank you for sharing your solution with the community @gusl!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings