Distribution

I need to import the unique sales Order records from Database table to Prepare Invoices.How to use “SOURCE RESTRICTION” in this case.?

I have a client that used an excel file to upload their physical count twice which had an additive effect. The Common Settings dialog box for uploading the count does not look like the dialog box used with other excel based uploads in that it does not include the ability to change the mode. I checked the help documentation and it clearly states that the mode can be changed. Is this a recent change or a bug?  

Hello, on Purchase Receipt Release action, we need to show user a Confirmation Dialog, then based on the input from first Confirmation Dialog, we need to show another Confirmation Dialog popup. On release action first Confirmation Dialog appears but not the second one. Please have a look at below code and suggest me what wrong am doing here. public virtual IEnumerable Release(PXAdapter adapter){if (Base.Document.Ask("Confirmation Dialog 1", MessageButtons.YesNo)                             != WebDialogResult.Yes) return adapter.Get();elseif (Base.Document.Ask("Confirmation Dialog2", MessageButtons.YesNo)                             != WebDialogResult.Yes) return adapter.Get();}

HI, We have created a Sales Price Import Scenario and It was not worked as we expected. As reference we have attached the Import scenario.  RegardsDulanjana 

Hello,Is there a report to check to see the top selling items by month?

Hi, Need to remove Inventory following allocation transaction. Actual Transaction is not showing this. But it is showing Inventory Balance Report. No need to show this Item. We disallow Item Negative balance in item class Level. Inventory Balance Report Item Class Level. 

Customer upgraded from 2019 recently and the highlighted item below “Update IN – Confirmed not billable” is what he used to select when processing sales orders that did not need to be billed (such as when you send out a sample shipment to a customer). Does anyone know if this has been replaced or why this is no longer there?  Is there another way to have these items selected when processing shipments?I confirmed it’s in 2020R1, not in 2020R2. Nothing in the initial release notes for 2020R2.D100 training references it 2020R1 as well, and not in 2020R2. Oddly enough, the documentation still mentions the action: “Update IN - Confirm Not Billable: To generate inventory documents for shipments made for transfer orders and returns with replacements.”Thx!-Chad» Screenshot from 2020R1 

Hi, We need to create Purchase Order using Multiple Requisitions. Ex: Need to create Purchase order as Follows. Need to orderItem A from PR-No 01 and  PR-No-02 =150 QtyItem B from PR-No 01 and PR-No-02 =210 QtyHow can we merge multiple PRs in One PO? RegardsNethupul             

I have a custom screen that has a parent/child standard editing form similar to sales orders in how it looks.Under the child grid or above it, I'd like to put a control that is bound to the same table/field as the child grid.It works to show the initial record's value from the child grid, but as I select different rows in the child grid it doesn't refresh with the proper values.  It always shows/edits the first value from the grid. Is there any way to get the control to show the right value from the grid and work like this?I realize I can put in the edit mode for the grid, but for ease of use this one field (multi-line HTML Editor) really needs to just allow the user to click on the row and edit the value easily. Edit:  Sorry this somehow posted to distribution.  Should have been in Customizations but I can’t figure out how to move it!

We need help with the workflow on changing the cost price of a SKU.  We have been manually updating “Last Cost” as the way we change the cost price of a SKU.  Is this correct way to update the cost price of a SKU?  If it is not the correct way to update the cost price of a SKU, what is the correct way to change the price?  

 Hello all, please help me.I try create SO with API but response always Not Enough Qty Available, Qty Available Will Go Negative!, i try again with another InventoryID but response is same.I try create SO in Acumatica and worksi try in Acumatica Cloud ERP 2021 R2 Build 21.205.0063

Dear all,somehow I suddenly get an error everytime when I try to save a new customer order…as a result of this error the whole customer order is gone...this is the message I get when clicking saving: “Error: Another process has added the 'PTSOOrderTextElements' record. Your changes will be lost." At the beginning it all worked fine. Then I tried to setup the product configurator...but I do not think that this might be the cause for this problem...Can anyone help?

I am trying to post a Sales Order type IN. I enter the line information, ie the inventory-id, location, quantity etc. I enter the lot/serial number. When I click plus to enter a new line the system erases my lot/serial number. I don’t know what I am doing wrong.

We’re finally starting to get a handle on Availability and Alloctions...I think We have a DEMO location with items we do not want included for normal Sales operations, but do occasionally ship to customers or distributors.  Unchecking the “Include in Qty. Available” is a necessity since we do not want these items to be considered as available for normal Sales Orders.  However, with “Sales Allowed” still checked, we can add the items from that location to a Sales Order, but we cannot create a Shipment. The documentation says this:Include in Qty. Available A check box that you select if the quantities of goods available at this location will be included in the quantities of available goods and used in shipments and transfers. Sales Allowed A check box that you select if only issues (direct inventory issues as well as the issues generated from sales orders) are allowed for the location. You clear the check box if no inventory transactions are allowed for this location, except for i

Can Landed Costs (e.g. levies that are %) be auto calculated upon products received from a supplier?

Hi,I have done Custom in Purchase Order ScreenIn POLine level am trying to update Curyunitcost according to InventoryID -(Stock Item screen-Valuation Method-Specific)equal to 0it is updating but in header order total is updating with the price cost which is defined in stock items screen..From Where it is getting updating am not knowing..Please Suggest me with the Proper solution 

 When my company went live with Acumatica in 2019 we were given access to a preview release of the carrier integration for ShipEngine.  Last week upgraded to 2021 R1 (v21.117.0037) which includes this feature out of the box.  Before the upgrade I unpublished all customizations and did not republish the early release version we had been using.  Before this upgrade everything was working for us as expected between Acumatica and ShipEngine.After upgrading to 21R1 I had to modify our carriers to use our ShipEngine Account ID instead of the API Token that the preview release required.  After that change the Test Connection button on each carrier reports success.  However, when I edit a ShipVia based on one of these carriers the service method selector no longer loads in any of the services tied to our account.Due to this configuration issue, we are not able to successfully refresh rates or shop for rates from sales orders.  We are able to create shipments successfully with update 17, so I d

Hello, We want to track transactions that are discounted, due to a misprint/reprint (we decorate our products). I’m assuming Reason Codes on the SO Line is the best way to track this, but please suggest any good alternative ideas. Is there a way to make Reason Codes required for discounted SO Lines? Our users will forget to input a code unless we require it. 

Hello,       Does anyone know is there a way to set Maximum order qty for a certain item on order line?Like we are having item A, item A is a hot sell item, so we want to set a limit that each order can only buy 3 at maximum. Is there a way to do it?

We’re using a slightly modified Inventory Balance report. Some items are being excluded from the report. Only common denominator I can find is these items all appear to show ZERO QUANTITY ON HAND and ZERO AVG COST. But I can’t figure out why that would exclude them. Like I said the file is modified from the original, so I’m attaching it here. TIA! 

I need to inquire about the do ability of having Quality Control or Check in Acumatica new version 2021 R1

Hi!If I have an attribute list type and I'm using it as an UDF within Sales Orders and I want to limit access to one of the attribute value for specific users, is it possible?Thanks!!

i want remove Quantity Control in Shipment Screen, is there a setting for that?

Is it possible to use the Mobile App and perform a spot inventory counting.Such as using the inventory lookup tool on the mobile app.Then going to that location and update the inventory on the fly?

Is there a way to do a spot inventory count without creating any Physical Count sheet.Walk up to the bin location and scan the the location, then the bar code and then enter the quantity.