Skip to main content
Answer

Blanket Sales Orders within GI's and processes

  • July 8, 2024
  • 2 replies
  • 127 views

jwright
Jr Varsity III
Forum|alt.badge.img+1

We will be creating Blanket Sales Orders, after being on Acumatica for a while.

I noticed that Blanket Sales Orders show up alongside the child sales orders on the SOOrder and SOLine DACs, which causes lines to duplicate in GI’s using these tables (For each child sales order line, a blanket order shows).

My current plan is to filter each GI (we have hundreds affected) where the order type’s SOOrderType.Behavior = “Blanket order” as a future proof if the order type id or additional blanket order types are introduced. (DAC)

Is there another route that doesn’t require a change to every GI?

Anything else I should be thinking through?

Best answer by dcomerford

Unfortunately you will need to modify every GI there is no way of applying a global filter

2 replies

dcomerford
Captain II
Forum|alt.badge.img+15
  • Captain II
  • Answer
  • July 12, 2024

Unfortunately you will need to modify every GI there is no way of applying a global filter


jwright
Jr Varsity III
Forum|alt.badge.img+1
  • Author
  • Jr Varsity III
  • August 16, 2024

For someone’s future benefit, I created an import scenario to add to each GI:
1. the OrderType table

  1. add a relationship to SOOrder
  2. add a parameter (checkbox to show BL’s)
  3. add 3 lines of conditions to make the BL operate.

Let me know if it makes sense.

(data provider was an excel sheet with a list of the inquiry titles with a columns in case one was missing from the sitemap)