We have a UDF on Sales Order - called "Customer Remarks". This field needs to auto-populate with the contents of the "Notes" field relating to the business partner that is added to the order. I have attached an image of the Values setup and the co...

In our company, for all Customers (not Vendors) we need to tick one of Properties 1-14 within the Business Partner (BP) to have complete information. We use B1 Usability Package, and have setup the below SQL Condition on the Add/Update button with Be...

For various reasons to do with product numbering customization on our SAP B1 system, we can have no more than two of our standard items on a row in a sales order or invoice. All other items, such as accessories and non-numbered items we can put as ma...

I need to write a query containing the following on each line: 1. The DocNum of each ORPC, OPCH and OPOR, 2. The NumAtCard from OPCH 3. The DocTotal from OPCH / ORPC or from OPOR if OPCH does not yet exist. Is this possible?