Need help with new custom field formula. I create custom field "Net Available Stock"
I have added the custom field to below screens, functions. now I need the field to work accordingly. I create a custom script for net availability and still having…
Hello, am wondering if someone can explain the logic behind Product Site Default Location setup? Problem: Snap shot above is how we are picking our apparel for replenish to work, but I don't think it's setup right 100%. Does anyone have any expierence…
Hello,
I want to make some modifications to SPEITM, but I noticed that our Sage x3 provider has done some of their own in a custom file, YSPEITM which they've called at the action runtime in SPEITM:
Unfortunately, this script does not exist in the…
When using the Product selection icon in any of the STOCK inquiries (Stock by site used for example), the fields in the pop-up window for selection are not those defined by the Product ITM object selection. Where can I find the field definitions used…
We recently upgraded to Sage 2022.1 and one of my employees was frustrated because every time she resized columns in the Sales Order lookup window, they would revert back - even after creating a custom view.
I tested it on a few other lookup windows…
We just did the SAGE 2021 update and something all of our people are finding an issue with is In SO entry screen under the lines tab we used to be able to have the columns in the order we wanted and have what we wanted to see and it would remember it…
We use UDFs on our Invoices to populate fields with both product codes and lot numbers. If those items are already part of the products invoiced, all is good. If we have to manually enter product codes or lot numbers, we have a weird issue. I'll try to…
I have a client who has a fairly heavily modified SO form (although we cut back from what we had previously done by quite a bit).
The client will have an issue with the Freight amount not saving on the Total tab.
I will go in and recreate the customized…
Hello!
I am trying to find a way to automatically export sales order data (specifically ship date) from business insights sales order view into a locked excel document provided by my customer.
It would be nice if i could filter a whole list of orders…
Hello,
We are wanting to further specify Quote orders as 'New', 'Converted', or 'Expired'.
Is it possible to add an entry to the 'Order Status' drop down in sales order entry? I'm assuming I will need to do some script/UI customizations to complete…
Hi Expert,
Currently, I need to customize my sage 50 software, something like add user defined field to sales order and sales invoice, create a customize form that I can define this page display and fields and logic.
Could anyone show me some lights…
I am trying to make a custom report in Business Insights Explorer that shows:
Item Code
Item Description
Product Line
Quantity on Sales Order
Total Quantity on Hand
But I cannot link a "Qty. on Sales Order" column to the rest of the report…
We are looking to utilize AR Customer Memos as a way to convey what special requirements a customer regularly has when they order. Ideally we want this on Sales Orders and Packing Lists. The issue is that when linking to the AR Customer Memo table, it…
I am trying to create a script that writes the current user key when the user prints the picking sheet. Has anyone done this before? My script doesn't appear to work and I am unsure which event I should use to accomplish. My code is below:
retVal…
One of the customizations we've added to our Sales/Bid Order entry line item screens is a column showing a product's available qty at the specified site. This is working correctly, however I would like to add more columns showing available quantities…
Greetings,
We are running an older release of Sage 100 (4.50.40) and we have a third party extended solution called M9-SO-1099 'On Demand' Sales Order Fill Report which was provided by Blytheco.
The manual for the add-on is here. https://wiki.blythecodev…
Has anyone been able to import using SCS and for an intercompany transfer?
We modified the import a little and we are stuck with an error: :Non-existent Stock
Hi,
I want to add "Q" status stock to the STOCK SELECTION object (STO), so that customer service can view all lots (A and Q) WITHOUT being able to pick the "Q" status lot numbers. Is there a way to do this? I know under Setup - Stock - Allocation and…
Hello!
A textbox has been added to Maintain Customer so that we can add custom notes. We would like to have these notes displayed in the Enter SO and QO task when the customer is selected.
I added a textbox and did a databind on custkey between my…
