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.
I have a crystal report that is pulling data from our posted AR_InvoiceHistoryHeader and AR_InvoiceHistoryDetail files and I have the exact same report pulling data from our un-posted SO_InvoiceHeader and SO_InvoiceDetail tables. I want to have the two…
I have a crystal report that is pulling data from our posted AR_InvoiceHistoryHeader and AR_InvoiceHistoryDetail files. I want to have it subtotal the quantities of each of the products and then print all items with a negative number on one page and all…
I need to let the system to calculate a discount based on Sales Order Header - 4. Totals -Order Total.
The formula will be 5% * Order Total . I need to create a UDF, UDF_DISCOUNT, under Sales Order Header - 4. Totals Tab to show this amount.
I don…
Thank you very much. It works.
However, how to get value from different module? For example, I want to get value from PO header to add to open sales order table.
Also, what are all abbreviation of different type of tables, such as header table, wrk…
I created a UDF, Estimated Delivery Date, in PO Header. Now I have trouble to add this UDF to PO Detail table. Anyone can help me?
User-Defined Field and Table Maintenance-->PO Purchase Order Detail-->Right click-->Edit Fields-->Green '+' on the right…