Distribution

can you sell both Eaches and Cases of the same item from the same warehouse? Also these products will have there own GTIN codes with them 

We sell a large and varied catalog of items, a segment of which is rope sold by the foot - one issue we deal with is getting shipments to be generated without splitting the location. When a customer orders 100ft of rope they generally want a single 100ft section and we don’t want pickers to pull from multiple locations to fulfill the line item. If we have stock in multiple locations, it would ideally drive the pick list to a single location based on the pick priority that has sufficient quantity for the entire line item. No split allowed I’ve wrapped my head around this multiple times trying to sort out the most clever way to force Acumatica not to split location IDs on these items or locations but failed to come up with anything that solves the issue. Anyone got a clever solution they’re already using?  Ideally, there would be a setting at the item level (class or inventory item) or even at the location ID that would say allow/disallow split locations. 

I try to update stock items screen, the LAST COST, by scenario. But the system shows me Failed to convert parameter value from a String to a Decimal.I have changed the format to numeric…. and many formats.Someone knows how to solve it.thank you 

We’re looking to revaluate the item which’s already set as moving average method. Could you please suggest and discuss in detail..

Hello  I have a problem with a report (sales order) that has chinese characters when exporting the report to pdfAlthough pdfFontEmbedded is set to TRUE  On the same report, I like to diplay deciaml with , separator and space (Exp 1263.35 ==> 1 263,35) Thnx in advance 

We have discount codes setup and assigned for all our items using item price class and customer price class and discounts are being applied properly in the SO document.However we also have special net customer prices setup for certain customers and items and in this case the price class discount is applied on top of the customer price we setup in sales prices.When a customer price is setup should this not be the final price and no other discounts applied?

We have a prospect who is ready to purchase Acumatica but have run into an issue with Landed costs.The prospect imports multiple items with different duty rates in one shipment from one vendor. When applying landed costs they need a way to parse the items that by class in order assign different duty rates.I thought of 2 solutions and need to know if either path would work:Add an Item Class filter to the Add PO lines panel or, Add an item class column to the landed cost TAB detail sectionSolution 2 would be ideal, if I understand properly, because it would allow a user to add multiple custom codes that would apply to only a particular class of goods.Am I correct? If so I will look at doing the modification.

Hello,       We are having some negotiated items with customer, which we markup fixed amount based on cost.Like Item A,  FIFO, fixed markup amount $ 5 per case       First Purchase,   $20 per case, then we sell $25 per case       second purchase, $30 per case , then we sell $35 per case.Supposing we are having 100 cases $20 item A and 400 cases $30 cases item A.The perfect solution we are seeking for:  is it possible that,  after the 100 cases of $20 be sold out, then the sales price automatically jump up to $35.If this is not possible right now. Is there a way that can automatically reminder the human that the 100 cases of old inventory be sold out, you have to update the price.Please advise. Thank you.

I am trying to configure the create and authorize process for our client but cannot get it to pick up credit card payments.From what I read and currently understand, I can use the Create and Authorize function in the Process Orders to look at all orders I want to ship and get a credit card pre-authorization.Client business process:The company will create products that are pre-sold up to 3 months before delivery. The same sales order may have multiple lines with different promise dates. When the product is ready to ship, the company will get a pre-authorizations to know what shipments should be created. The card will be charged once the shipment is confirmed.Configuration and issue:I set up a client with visatok as the payment method in the demo system. I entered a sales order for an in stock item with 2 lines. One had today's date and the other one had a future date. I used the create and authorize from the process order.Nothing showed up in the create and authorize screen. To validate

I have the outlook integration working properly but I don’t know which site I am linked to. (I have multiple dev sites that I would need to work with). How do I know to which site am I linked to and is it possible to change from one site to another?Thanks 

At the Summit, an integration with Amazon Business accounts was shown whereby an order placed on Amazon would be pulled down into Acumatica for approval.  Once approved, Amazon would be sent a message to pick and complete the order. What is the status of this?  Is it still planned?

Hello, we need help in recording Audit History when doing direct DB Updates, for some reason we are doing direct DB Updates to one screen, the data is updating correctly but that is not getting recorded in Audit history, do we have any other way to record audit history even if we are doing direct DB Updates. PXDatabase.Update<TableName>((PXDataFieldParam)new PXDataFieldAssign(“FieldName”, “FieldValue”),(PXDataFieldParam)new PXDataFieldRestrict("TableId", TableId));

Hello Everyone, Is there a way we can specify the period for the Inventory Balance report? Thank you.  Kind regards,mrivera67

When we tried to upload the file to the Document Detail tab under the sales order entry window, it only uploaded up to 1000 items. So is that the maximum line item we can enter in any single sales order entry? And do we have any alternatives that we can exceed 1000 line item in one single order? Sometimes we have a large order that might have thousand and thousand of BOM (Bill of Material).. In addition, we experienced tremendous of slowness when the sales order has reached about 1000 line items. For example, it might take us 3 minutes to update the pricing for one single line item or just change the characters of the stock item description.. it really create a bottleneck for our operation efficiency. 

Hi:Does the stock item status have a predefined workflow? I couldn’t find one. If not, can I create a custom workflow from scratch for it.?I could not find any information about the visual workflow editor in the help guides. Please help.Thanks.

Does anyone know what this is or how to fix it?“Multiple controls with the same ID 'dt1000246' were found. FindControl requires that controls have unique IDs.”

It’s important for a number of clients to get confirming of price and delivery from the vendor and not allow receipt of goods with confirming the PO.  Manually you could keep the PO on hold or add something to the workflow.  Does anyone know of a way to “force” the vendor to confirm the PO perhaps some integration to DocuSign or Adobe sign that could communicate back the customer that the vendor has received and confirmed the PO.  The vendor of course could offer a different price and/or delivery,

After setting new prices for template items in the vendor price worksheet, the vendor price for the variants of the template item will not get updated. I can’t figure out if this is a bug or a feature.

About: We would like to gather your feedback regarding our credit card authorization and re-authorization process. This is important for commerce and distribution companies which process special orders or take orders with a long lead time before the order is shipped.In this focus group we will:Providing a short demo of credit card authorizations and how it works today Discuss how to manage expiring authorizationsAudience: Customers and partners who need this feature or have knowledge of workflows and how it can be delivered.Date/Time: Dec 16 @ 8:00 a.m. PDT / 11:00 a.m. EDTRegistration: https://webinar.ringcentral.com/webinar/register/WN_ExcQopQXSO6qE_bAsksWQg

Hi all,We are looking to use the shipment confirmation form as a pseudo Bill of Lading as a way to notify both parties of a transfer that has been created. Standard form has Ship To location but there is no ship from or Shipper address information. Since there is a from warehouse listed I am assuming I can edit the report (and tables) to query the ship from address off the warehouse location. But I don’t know what tables and relations I would need to create this.  Any ideas? 

I don’t think this has been said before but I wanted to ask here just in case…We have a extensive warehouse and we are planning on doing an inventory run sometime soon. We have just upgraded to 2021 R2.​​​​​​ And we are using handheld scanners for the first time instead of physical sheets.When doing a physical count, is there anyway to see what logged in user on the handheld scanned which item? We don't seem to see a way to do that. When you select the confirm button, it confirms the whole PI number and selects all items within the PI List  from ‘Not counted’ to ‘counted’. Thus we are losing visibility to what we are missing as items not counted yet will show a qty of 0. Is there a way to ‘Update’ what was already scanned and confirm single items were counted?

Hello,    Is there a way to fulfill my need below.Let’s say, for Item A, we left 200 cases in stock, so We’d like to go on promotion for the 200 cases only, because during the selling time, we might do purchase and receipt. So I’d like the promotion price only apply to the 200 cases.  So the ideal scenario shall be $10 promotional prices would fill in orders allocating the 200 cases, after the 200 cases be sold out, $15 （which is the normal price） would be filled in.  Note: For business requirement, we must use the same Inventory ID.

When I go to “Print Sales Order”, and then go to the Email option to choose a contact for the To: address, the default is to search the global list of contacts. Shouldn’t the chosen Contact for the Sales Order be pre-populated? And also, shouldn’t the short list be the Contacts attached to that Customer, as opposed to searching the entire Contact database?

Hello Everyone,We have a requirement to enable the approval workflow for the Bills and Adjustments screen. Credit/Debit adjustment or Prepayment should not be approved by created by user and it should be approved by only user from specific workgroup.