Inventory, Orders Management, Warehouse Operations
- 702 Topics
- 2,498 Replies
When you have an inquiry, you can copy-paste the data from the fields in that inquiry into a screen.I use Purchase data to build Sales Orders and I need to copy-paste a date. If EVERY digit is filled in, this works like a dream. If not, this goes very poorly. Can we force zero’s on dates so that copy-paste works as intended and doesn’t just give out bad data? Example of a BAD date: 1/3/2022Example of a GOOD date: 01/03/2022 Here is the issue: SOURCE INQUIRY (copying ETA field) DESTINATION FIELD Due Date, after copy-paste (without exiting the field): If you click or tab out of the field: So now instead of copying the correct date, it slapped in the day of “today”, but on the proper month, but then also applied the wrong year. Obviously, people who are constantly copy-pasting are going to miss this, and it creates a large burden of work on our end. Can we get dates to work like they should please? Hopefully, I’m just missing a setting somewhere :D
Hi, We need to update the Item Cost base on the FIFO cost method. Ex. Item A - 20 Qty with 10$ After add the Laded Cost Value for particular Item Cost, it would be 12$. Have there any possibility to update the Item cost manually? Since user already has completed the landed cost process without adding additional 2$.Now we need to update that additional 2$ to Item. RegardsNethupul
Hi, Is there a way in Acumatica to look up pricing for a customer?As in the customer calls and asks how much is an Item and you can check? Without having to open a Sales order or Quote to do this?Something similar to the “Catalogue” in the portal but where you could select the Customer. Think writing a GI to do this would be over complex due to the different types of discount a customer could have CheersAndy
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,
As per the below screenshot in D210 guide-2021 R1/2022 R1The following error is getting triggered whenever the PO Order number is entered.RECEIVE MODE IS IN USECannot create a purchase receipt for the 000077 purchase order. Create a purchase receipt manually.Error: Inserting 'Purchase Receipt Line Split' record raised at least one error. Please review the errors.Error: 'Location' cannot be empty.Scan the receipt number.Can you please let us know how to create this?Thanks.
Hello, We have multiple branches, like branch 1 and branch 2. For customer A, both branches served the customer years ago and also issuing invoices separately. However, starting from this year, only branch 2 is serving the customer.But every time, when we prepare customer statement for Customer A. It looks like system also generate 2 statements, 1 is for Branch 1 and the other is for branch 2.Branch 1 statement is empty and unnecessary. Is there a way to excluding branch 1?
Hello, i am trying to work on non stock kit flows:image 1 shows the non stock kit simple two components.image 2 and 3 show the sales order and shippmentimage 4 is action print picklist, but why the pick list does not who the two components as specified in the kit spec as in image 1? RATHER, it only shows to pick the non stock kit.. please help anyonethank you IMAGE 1 image 2 and 3 IMAGE 4
HelloI was wondering does anybody use Shipment Confirmation form as Delivery Note and Cargo Shipping Order? If so, how is it set up? (Just for reference we are not using any Integrated Carries options).Normally those 2 documents are generated separately but in Acumatica I cannot see any other documents related to Shipment as Shipment Confirmation.Thank you in advance for any tips.
Hi,I am new to Acumatica and need assistance setting up a Generic Inquiry. I was able to setup a GI but the information looks incomplete.We want to create a GI that shows invoices under Bills and Adjustments for a project that has a pending status for the Project Task and Inventory ID in Bills & Adjustments under the Details tab. See first screenshot below: The next three sceenshots show the configuration and results. What am I missing in my GI setup? Any information would be helpful. Thanks. Relations Setup: Results Grid: Inquiry Results:
Hi, (01). After expired the sales quotation we need to restrict sales order creation using expired sales quotation? Further understanding, I have attached a document with screens. (02). Also need to know how we can build the link sales quotation number and sales order number? RegardsNethupul
From my brief research and testing it would not appear that Acumatica allows for a workflow where Landed Costs can be entered and paid for prior to the purchase receipt. Has anyone figured out a way to accomplish this cleanly? Like many companies, we are importing items from overseas and paying some significant landed costs in the form of freight and duties. We want to capture these costs and apply them to our item costs, but often we need to pay bills before items are received. Neither the freight companies or the brokers are interested in waiting for us to receive the inventory before they get paid and I imagine this is a very common scenario - is this a simple oversight in the Acumatica functionality? or have I missed something obvious? Appreciate any insight others have in this area
Hi everyone,We use the mobile app for a while. The problem is when review the list. The first column should be the inventory id or location id. But the screen is showing the description for the inventory id or location id. I have no idea how it happened. I checked the code in Mobile Application. It’s use the current field. Anyone knows this problem ? Thank you so much.
I have created a second PXSelector that mimicks the behavior of the out-of-the-box UOM field in the Sales Order entry screen. I have detailed the process of creating this below; I have basically copied all the elements I can find from the existing UOM field (and renamed to jUOM as necessary). Everything works, except I get an error when saving the Sales Order document that says “Invalid column name ‘jUOM’.I am stuck trying to figure out how to create an extended field on the SOLine cache that can save the value chosen by the user for this second UOM field (called jUOM) to a field in the database.I confess to not really understanding how the out-of-the-box UOM field is being saved to the SOLine database table, which is part of my problem. I have played around with using PXDBString etc, but that breaks the UOM selector (can’t be used with the: [INUnit(typeof(SOLine.inventoryID), DisplayName = "jUOM")] DAC field declaration).Can someone help me makes sense of what’s going on with these U
Hello, We are on Acumatica 2020 R2 Build 20.215.0025 with some customizations that have been published. The Prepare Replenishment process used to take under a minute to complete. However, by simply deleting an old Snapshot the process now takes ~20 minutes to complete. I can replicate this issue over and over again in a SANDBOX environment (by restoring to a SQL backup prior to removing the Snapshot), but I haven’t found a way to fix the process after the Snapshot has been removed. Has anyone experienced this before? Any thoughts or suggestions would be much appreciated! Alec
Hello Everyone,One of our clients using the Pricing Analysis functionality in the Sales Order screen, but we do not want to show the Zero unit cost items on it.If anyone knows about this functionality could you please let us know how can we achieve this? Please find the some screenshots for your reference.
In the case where an employee sometimes is reimbursed for Employee expenses (Travel, Living, Lodging and Entertainment come to mind) but also provides services which are not part of their employment contract, i.e. Advertising.When entering the bills for these activities, is there a way to indicate for each item whether it is reportable as a 1099 reportableactivity as opposed to an employee expense re-imbursement, which would not be considered income, and should not be reported on a 1099.
Good morning. I have a client who needs to generate recurring sales orders to fulfill a quarterly magazine subscription. In an attempt at creating the most streamlined account setup workflow, I have proposed this solution:1) Create Customer Template for Magazine Style (4 to chose from)2) Store Subscription details in the Customer Attributes with details Then trigger automated Sales Order Generation based off of Customer Attributes. However, this last part in the process has proven to be above my head. My general concept was to create a GI that would pull customers that match this profile, then generate a sales order from 1 of 4 templates, using 1 variable from the Customer Attribute (qty of magazine line items per order). Here is a screen shot of my attributes setup.Build 19.205.0023 Any ideas on how to make this happen or another better idea that is more simple?
I am new to Acumatica. We have one client who only has one entity setup (no branches/multiple companies) In the past there was no need to setup a default payment method and cash account for each vendor (single entity). However, when I try to hit the Pay button I get an error message pops up (See second screenshot). Also when I go to Prepare Payments not everything is showing up. Note: In A/P preferences the item to require approval for payments is not selected. Let me know if something changed recently or is it now a requirement to have the vendor or vendor class have a Payment Method and Cash Account selection. (This is even though there is no* by the field). Any help would be appreciated. Thanks, Frances Pantelidakis
Login to the community
Social LoginLogin with your Acumatica account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.