Distribution

Hi guys,With the phasing out of sub-items has anyone taken up the challenge of moving from sub-items to Matrix items?We have discussed with Acumatica and they do not have any options other than a complete re-implementation of the client using MAtrix items.

I have Mentioned Markup Percentage in Item Class Level which  is not Working , Where as when i am creating Markup% on item Level its  Working . Kindly advise what need to me checked  or what is the concept in Using Markup % from item Class Level

Hi community. Please assist, I have. An import scenario that is triggered by a business event. The Business event completes but with an error for the import scenario. however, when i resume processing of the event from the BE History screen, it runs.    Please assist , what am i missing.?

Client uses multipliers to calculate min and max dynamically. In order to work on a possible solution we need to import historical sales so that we can have Acumatica generate a daily moving average.Two questions:How should those historical transactions be imported? (invoices, issues, etc) When doing the calc for daily moving average, how does Acumatica do that math? Is it taking into account number of business days in a month vs the total days in a month?

We currently are assigning lot numbers at the kit creation level, but would like to switch to assigning lot numbers at invoicing instead. Can we simply change the lot class of each item in our system to have the lot be assigned when used instead of when received?

I imported inventories against a default warehouse an location. However, decided to remove it later on before entering any transactions. Bulk removed default warehouse and locations from ‘inventory card’ and ‘Item Warehouse Details’ screen.Now when creation purchase order and using ‘Add Items’ button, system still holds this information in inventory lookup as a siteID value.If adding lines manually using + button it’s all goof. Only when using below Add Items button. How can I remove warehouses from here?  

When enter purchase receipt unit cost of inventory change difference from purchase order. I don’t why it has happed. Here it is 

When we figuring out stock depletion, we often run into trouble with quantities on open blanket purchase orders. For example, we will look at inventory summary and inventory allocation to see a list all current inventory on hand, supply and demand. However, there doesn’t seem to be any report tied to the inventory item that includes quantities open on a blanket PO. As a result, contracts reflected in blanket PO’s are overlooked when we’re planning the phase out of an item resulting in all sorts of issues like restocking fees, large scrap values or modifying deployment plans.Is there any way to have visibility to open blanket PO quantities when looking at inventory summary or allocation? Is there any reason that these screens wouldn’t/shouldn’t include quantities on blanket PO?

Hello Everyone,We are looking for to adopt a 7 segment inventory id. One of the segment is Item Class. Thinking about using Attributes and make the id created automatically. Its not clear on how the ids get created using attributes and segments. Already referred Matrix items, Templates as part of the research. Has anyone went through a process of multi segment inventory id. how easy is to create and maintain the records? Is there any value on creating multi segment like for any reporting? Ease of use, read challenge, etc. Any challenges that we should be aware of. Appreciate any insight.Thanks,

Dear Connections: Due to the way this inventory is lot/serial managed, I receive an error when I try to enter the conversion factor: "Fractional unit conversions not supported for serial numbered items."  The conversion factor will be 0.133GM and I'm trying to key in the conversion UNIT PKT SalesUOM>. Even though I also tried switching my BASE UOM to GRM, the problem still persisted.  Appreciate your advise on this situation.  Refer to the attachment below Thanks Ram 

Please help! We are down!Has anyone ever seen this happen before? I cant access my sales orders, this is the error message that pops up:Error: The entry form (ID: SO301000, title: Sales Orders) cannot be automated. Object reference not set to an instance of an object.

Is it possible to create one SO invoice with multiple delivery notes in Acumatica when goods are delivered to separate customers but one customer pay for the products

We have been trying unsuccessfully for several days to get Easypost setup in our acumatica instance.  Anyone know a VAR or someone who can assist us?  Our Shipstation has been down for over a week and we need to ship.    

We have a client that only has Non-stock Items.  They have assigned a non-stock item to a vendor.  However when creating a normal PO, and using the “ADD ITEMS” button on the grid, nothing shows up.This ADD ITEMS button works with inventory items for another client, and narrows the selection to only the items assigned to the vendor.  Why doesn’t it work for non-stock? Am I missing something in the setup? 

We are trying to schedule (automate) our Request to Requisition to PO process. However, we think the process will need manual intervention to change the Requisition status from On Hold to Open before creating POs. Is there an option to turn off the status of the Requisition automatically being created as On Hold? I can see an option to do this for the creation of the PO, in the Purchase Requisition Preferences screen (checkbox called Create Purchase Order on Hold), but nothing for the Requisitions.Thanks.

I’m trying to create a Generic Inquiry in Acumatica for a inventory stock status report. One of the requirements of this report is to show the 12 month rolling avg of the quantity sold for each item. Is there a way to do this in Acumatica? We just need to see the 12mo average quantity sold. I do not see any fields that would provide this information. 

Unable to confirm the shipmentShip via: UPS (Next Day Air)Country & Postal PR - Puerto Rico 00646Error: SO Error: Carrier Service returned error. 120502:InvoiceLineTotal MonetaryValue must be greater than 0  Send   Raised At: 9/22/2023 11:49:20 AM Screen: SO.30.20.00      Details: 9/22/2023 11:49:20 AM Error: SO Error: Carrier Service returned error. 120502:InvoiceLineTotal MonetaryValue must be greater than 0    at PX.Objects.SO.SOShipmentEntry.ShipPackages(SOShipment shiporder)    at PX.Objects.SO.SOShipmentEntry.PackageDetail.ShipPackages(SOShipment shiporder, Action`1 baseMethod)    at PX.Objects.SO.SOShipmentEntry.<>c__DisplayClass57_0.b__0()    at PX.Data.PXLongOperation.<>c__DisplayClass18_0.b__0()

Hi, A client has found that an item in the Prepare Replenishment query is showing no value for the Qty to Process screen, but it looks like it should be showing a value since a customer has ordered 2 of this item and the client only has 1 of these in stock. Is this query result incorrect or can you see a reason why the Qty to Process column is set to 0? Kind regards,Andrew 

We have an issue wherein we may enter part of a Sales Order, or the full order, and then place it on hold awaiting some further information. The Sales Order may be on hold for several days.  We are on 22R1 Build 22.119.0027 When you go to Prepare Replenishment, however, the replenishment calculation seems to include all orders, including those on hold, in the demand numbers.  This can cause inventory buyers to purchase items that may not be needed because we have changed the Sales Order lines or quantities before releasing it from On Hold status. Is there a setting to have Replenishment ignore demand from On Hold Sales Order, much like the Inventory Availability Calculation Rules can be configured for various scenarios.  Alternately, it would be useful to have a “Draft” Sales Order Status where the order is not visible at all to other modules in the system until the Sales Order is released. Has anyone else struggled with this scenario or had successful workarounds? Thanks in advance.

My customer is looking to create a customer credit term where a 35% prepayment is required on initial sales order entry and then the invoice when generated would be an installment of 35% due net 30 and 30% due net 60. Currently you can create Multiple percentage installment plans but cannot require the prepayment at sales order time but it does generate the two invoices with correct due dates. If I do single installment plan, it will allow prepayment but I only can have one due date for the balance due. I can see that you can create an installment plan with a day of zero for 35% but this does not require prepayment on sales order. Just creates an invoice due today. This also assumes I need to invoice immediately before shipping. I think I may be able to get creative with cash discount being 30 days with zero discount % and make the total terms net 60. But feel this could cause confusion. Trying not to customize too much if possible. Any ideas are appreciated! 

Hello!Is there’s a way to use one warehouse for all the branches, without creating multiple warehouses. Since the branch is mandatory in the warehouses profile and it posts transactions for the selected branch of the warehouse, it is unable to use one warehouse for all the branches. Thank you in advance!Amanda 

Hi Team,We don’t see the Relations View in the base graph SOOrderEntry or Extended graphs, whereas available in the aspx.Could you please help us how to access that view in the custom extension graph of the our customization.  Thanks & Regards,Vidyakeerthi K

I’m trying to setup UPS integration with Acumatica. Looks like it’s no longer accepting API credentials instead requires OAuth. Does anyone have setup documentation?Is this the same issue with Fedex?

HiIn apparel business we are using multiple size ranges and at the moment i have problem with displaying them in one column in GI or reports   some of size ranges  Attributes of size rangesI tired to use simple formula =IsNull( [InventoryItem.SR-1_Attributes], IsNull( [InventoryItem.SR-2_Attributes], IsNull( [InventoryItem.SR_3_Attributes]….. )))to display them in one column that is partly working, as I have them in one column , but as result is only displaying them as Value ID (0401,0402...) and cannot get display attribute Description (XS, S, M ...) in that column.Is there any better way to do it ?