x Want to participate? Join the group to interact

Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Business Object Interface

Consolidated billing query with AR_InvoiceHistoryDetail

Joshua Bloomquist

We are trying to write a query or stored procedure to identify the cash receipts for each of our franchises (warehouses) but ran into some trouble with consolidated billing. Since payments aren't applied to the line items we need to create a lookup table…
- Answered
- over 3 years ago
- Sage 100
- Business Object Interface
Set Sage field equal to UDF (user script?)

wishingforsql

Earlier this year I created a mobile application for pulling orders. To integrate, I made a rather barbaric implementation: when the mobile application backorders an item, update SO_SalesOrderDetail.QuantityBackordered = External.QuantityBackordered.…
- Answered
- over 3 years ago
- Sage 100
- Business Object Interface
Using SQL in script

Jon_K

Does anyone have a very basic example of how I can integrate a SQL statement in to a script? I've run into plenty of occasions where I wish I knew how to accomplish this, here is my current goal: We ship using Starship and for a variety of reasons…
- over 8 years ago
- Sage 100
- Business Object Interface