Distribution

My client has multi tier pricing structure where essentially a customer can have more than one customer price class. So how it would work is Customer A, Item A could have Tier 1 = $100, Tier 2 = $90. The sales price would be the minimum price so the system should automatically select 90. I’ve tried using Sales price worksheet but no luck because a customer can only have customer price class and I’ve tried using the alternate ID as a tier category but it errors out because of the same active date range. Any ideas?

I think I am missing something. I will admit we a running 2019 R2 with 2023 R2 being launched next week. When we order stock items, we change our current cost on the PO#. When we create a PO receipt why doesn’t Acumatica change our current cost?  Is their a solution for this?

I’m trying to setup auto-replan of back orders for my client but got into a problem.Based on this wiki below, the line is sorted based on Ship On date starting from the earliest one which makes sense. But why orders with the same Ship On date are not sorted based on time they are entered on that date or based on lowest sales order number? Instead, system replans based on the greatest quantity. This is a problem when order entered at afternoon with greater qty gets replanned first than order is on back order in the morning.  

Is there a way to assign a weight (possibly at the time the PO Receipt is entered) to a lot/Serial #?  We would like to have a way to show the weight on an item on the shipment confirmation.  We use lot tracked inventory items for a wide variety of special order items so it wouldn’t be possible for us to assign the weight to an Inventory ID.Thanks 

Hi EveryoneWe have created a Business event to create a task using the Action Execution option in the Business event.When ever the Owner changes in Opportunties the Business event should create a task.We are getting the error ‘Error: The argument cannot be null.Parameter name: key 

Can anyone tell me how to or why you can’t relink a quote to a different opportunity in CR304500.I’m fairly confident I did this somewhere else in Acumatica recently with another process, but I can’t recall it right now.  

Hello Commerce Customers,Could you please help me in understanding how the multi-warehouse location inventory for the Commerce orders works? How does your commerce system select the required location when the order is placed by the consumer?  How does Acumatica select the warehouse location when the orders are imported into Acumatica?  Do anyone of you facing issues related to this?  If yes, please let us know we would like to connect with you and learn about your business process and help you by implementing this feature out of the box. 

I made a copy of the default Customers GI,  we are going to make some changes to this GI.  Before making the changes I made a copy of the existing GI and tried to save it.  I am receiving the following error.  There are no boxes checked for mass update.  Please help this is kinda urgent!! Here is the trace log that goes with this error 

AR Statements were prepared for 12/31/2024 instead of 12/31/2023 at the beginning of 2024. If we try to go back and prepare for 12/31/2023 no Cycle IDs are shown as options. The only way for the correct Cycle ID to show is if we choose a “Prepare For:” of 01/31/2025.I created a new Cycle ID, MONTH, using a different Schedule Type but that did not work and did not process any AR statements. It appears that once a statement has been processed for a future period there is no way to go back and correct the date. This appears awfully draconian as it is easy to enter the incorrect year, especially at year end.Does anyone know of a workaround or a way to be able to reset the “Last Statement Date”.Thank you

This may be a similar issue to canceling a PO that has been fully returned.  We have a PO with multiple lines.  One line was received then fully returned.  While attempting to delete that line, the following error message appears.  “PO Error: The line cannot be deleted because some quantity of an item in this line have been received.”I am aware of trying to cancel a PO that has been received and the solution of setting it to complete.  Just curious if this is a similar issue but on the line level and if the solution is to complete the line instead of delete.  Thanks!  

Is it possible to scan an item during picking/packing and automatically set quantity based on its qty in a box?Example:There is 30 ea of the product in a box. A shipment needs 60 ea of it. When picked, scan the item barcode twice instead of keying qty 60 ea manually.

Looking for a user of Shopify Plus where you’re shipping B2B , have backorders, pre-authorizing credit card , amongst others.  Would love to connect.  

We are using the mobile application, Pick, Pack & Ship function for picking shipments, using Honeywell Android mobile CK 65 scanners.  Using the Pick mode, the application has stopped placing the focus on the Location, Item and Lot fields when scanning.  When starting the Pick process the application prompts the user to scan the shipment number correctly.  The next scans are for location, item and lot.  The cursor no longer is placed in the location, Item or lot fields for the barcode scan to register the scan results in the field.  The user must touch in the location, item or lot fields to place the focus in the field for the scan to register.  This stopped function last week, no updates have been applied to Acumatica (23 R1), the Honeywell scanners or the Acumatica Android application (last update from the Google Play Store was 12/16/2023).  Does anyone have any idea why the mobile application would have stopped function correctly?  Thank you.   

How do I change the default in Inventory “Goods in Transit” report from “Summary” to “Detail” and in fact, how to change defaults in general? 

Hello, We have Child Orders created manually and moved to completed status, we need the ability to link this child order to the Blanket orderFor Clarity:Below is the child order created manually Below is the Blanket order.As we don’t see the ability to link this can you please guide us? 

Hi all, Can you help me about my concern for creating a Sales Order and when we ship this item, we encountered this.(Please see the image below)  We resolved this issue by creating another (copy SO) and the shipment and the process continues smoothly. Do you have any solutions to rid this? Thanks

I am getting the following error when trying to Correct a Shipment already confirmed but not invoiced, “The line cannot be deleted because it is linked to a purchase order”. This error is new to the upgrade however I upgraded 2023 R1 and R2  at the same time so not sure which may have caused this.  Items are not marked for PO or anything that makes sense. 

Please assist, I am trying to use the switch formula on the report design, but i get an error when validating the formula. I don't know what i am missing.   

Our customer often encounters the following: customer order 900 lotted items (lotted, when received, user entered lot nbr) which they mark for PO, PO is created for 900 items, vendor overships 1000 items, customer agrees to buy all 1000. Because they are lotted, the only way we have been able to accomplish this is to go back and update the quantities of the SO and PO to match the end qty of 1000. Then they do a PO Reciept for the 1000. The problem comes when trying to create a shipment. The shipment only wants to ship what is allocated, which is the original 900. And Line Details on the SO is acting like they need to create another PO to satisfy the extra 100 - I cannot uncheck the Mark for PO box. Screenshots of the entire process below.Original SO for 900 marked for POQuantities on SO and PO changed to 1000. Then…Purchase receipt for 1000SO line details has allocated 900, not 1000Can’t uncheck Mark for PO or check Allocated on the third line. Adding a new line acts the same. They cou

hi all i have two questions#1 is it possible to add lines to a sale order by hitting the enter key or is it strictly using the plus symbol ?#2 can you release an invoice to sell quantity you didn't enter the receiving yet thanks

Hi everyone, Thought i would share our recent experiences in case anyone is experiencing anything similar. We have been unable to export quotes and I could not find anything on here about this turns out that there is a known issue where if the opportunity has any attributes, the error message ‘The multipart identifier ‘CROpportunity.NoteID’ could not be bound’ appears. Our VARs escalated this to Acumatica  support who let us know that this is a known issue and that this is fixed going ahead in version 22.212 and above.

Hello,Order types have a checkbox setting for“Ship Separately” and “Bill Separately”However, I do not see where we can designate this for a customer.We have some customers who want this and some who do not and we need to control it at the customer level.Any thoughts or guidance are appreciated!

Hi, for new sales offers we would like to use the vendor price of the standard vendor as base for our calculations. But the standard sales order screen does not show it. It seems that there is a customization nessary.Did anybody do this already or knows how to do it?CheersLars 

We use kits in Acumatica and send the kit SKU to Shopify. We need a way to automate the update of kit inventory in Shopify using the Acumatica Shopify connector.  Is there an app in Shopify that will maintain the kit components?  Can the kit component inventory be sent and received with Shopify via the connector?  

Hi allIs there a way how to set up a special discount for a certain unit of measure,  but it should only give that discount for a particular customer price class, also even if that customer is part of a that price group class ,if that particular customer get a standard invoice discount of let's say 20 percent it should not give that unit of measure discount I don't want the customer to double dip or for example if a certain customer has a special promotion running for a certain date period even though he is part of that price group he still shouldn't get that unit of measure discountis that a  possibility Thanks