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.
Is there a way to add the Quantity Ordered and Back Ordered fields from either the SO_InvoiceDetail or SO_PackingListWrk tables to the SO_AdditionalPackingListWrk table?
I've tried creating an UDF via CM under SO Additional Picking List Work, but I…
Hi Sage City and Happy Friday! I have been working on a button script to launch Sales Order Entry from AR Customer Maintenance. The goal is to click on the button and open SO Entry, automatically select the next Order Number and pass the Customer Number…
Does anyone that knows how to control and allow salesperson to be able user lock the by the salesperson to be able to see only see their only their customer statement and sales order invoice but no other sales representative. Currently, the lookup is…
Currently you cannot make changes to the sales order without closing the Memo screen. I'm trying to launch Customer Memo from a button in Sales Order entry.
I tried
retval = oSession.InvokeProgram("AR_CustomerMemo_bus.pvc","CustomerNo")
The retval…
When invoicing RMA's, we use logic in a custom script to set the cost account key and the sales account key on the line items based on based on the customer division. When I go to the newly created invoice, the sales account key has the correct value…
I want to thank everyone in this forum in advance for the wealth of information you have posted and gathered here. With that information, I have been able to apply a script to automatically print Sales Orders once they are entered. The script below runs…
In Business Insights Explore, is there a way for me to have the Data Field information and the Preview Field information on the same report? I've got all my fields the way I want them, but I don't want to just see the Invoice History, I want to see the…
I added a tab to my Invoice Data Entry panel with UDFs
I want to be able to select an option in "SCAC Code" which will then display the proper name of the carrier outside of the SCAC Code dropdown. I want the SCAC Code and CARRIER NAME to be separate…
Hello everyone,
I created an extra tab in Sales Order/Invoice Data Entry and I have a few questions:
Most importantly, how can I use the data that's selected and inputted here to generate a PDF or other type of document? Each of these fields is built…
I am trying to warn the user with a message when entering an A/P invoice and selecting a Job that is no longer active. Since there is no Active/Inactive jobs in J/C ,module, the customer is using the Sort field for this purpose. For jobs that are active…
Hello, I'm curious to know if I can create user defined fields in Sales Order Entry and the same fields in Invoice Data Entry?
The fields are populated in the Sales Order Entry window, and then transfer to the invoice. The fields are in be added to…
Hi everyone, I'm using Sage 2013
I've added a new tab to the Sales Order module in Main > Invoice Data Entry
I've added fields/UDFs (some are already ones that existed), but I'm unable to add to anything in this tab or figure out how to get some of…
I am trying to get an event trigger when an item quantity changes so I can perform a real time update in a UI. I have tried setting Post Write Events on IM_ItemWarehouse and IM_ItemTransactionHistory, but although I can see the DB Tables changing/updating…
We have a client that would like to add the Weight field that is shown on the Main tab in Item Maintenance to a new tab he created. I am not asking to move the field from the Main tab, just repeat it on the new tab. I thought perhaps to create a UDF field…
Has anyone installed the F9 software version 4.5 with Sage 2019? We currently have 2016 and it works fine but we are about to upgrade and before we make a change I thought I would check.
Hello I was just wondering If I can trigger a user defined script, with table IM Item Warehouse? I'm looking to trigger a script when there are changes on an item inventory. I see a field named Available on Item Maintenance > Quantity, I'm assuming this…
I have created the same udf in sales order detail and SO invoice detail entities. Both same type - string - and same size (20). In the data source from SO invoice detail I have selected "copy from sales order and for data source I have selected SO_SalesOrderDetail…
Hi,
I have a UDF created in Inventory Management in tab 8. Web, which is called UPC, so I can add this information into Sage 100.
I'm wondering if there's a way to bring this UDF for UPC from the tab in Inventory Management to the Sales Order module…
We have a lot of information in our header tab already and when we print our sales order the space is mostly allocated. We have a new UDF field that we need to create and I am trying to figure out a place to put this new information, was hoping in the…
Hi friends,
We have a business requirement to have a vb script that would pop up a message box on the sales order entry as soon as we tab out of customer no field or set as a user-invoked button.
If the customer has any open invoices that are past…
Hello,
I am trying to come up with a counter for the number of orders (Standard or Backorders) that an item is on. So far I have tried a script that counts the line inside of SO_SalesOrderDetail but it won't write to the two UDFs made in CI_ITEM. Has…
Can anyone tell me where I can find step by step directions on creating a custom check history payroll report? We have 3 departments and within the departments employee work within department numbers. I can print the payroll check history report and break…
We enter our orders in each qty, but would like to show a field with the calculation of case qty. I don't need this value stored, just would like to see it on the screen. I have added my UDF that contains the case qty to the lines tab. I don't see how…
We have a parameter in our Sales Order form that changes what is printed based on the parameter. I would like to have it print to a particular printer based on the parameter selected. Actually I want to print from a particular tray in printer based on…
Is there a way to restrict access to standard report settings while allowing employees access to custom settings? We recently upgraded to 2018 and use the Job Cost Module. The Job transaction detail report is something we use frequently but since we upgraded…
