usually, we have a specific Pricebook in SFDC to link up to an order and each pricebook only has 1 Currency,but on occasion there are multiple price books in Epicor so in SFDC I would use the Standard price book and when I create the opportunity I wo...
our ERP will allow a user to enter a serial number like 1234*is there a way to test of an * or & or @ etc is in a text field so i can send an email to a user to fix rather than move the incorrect data to SFDC thanks
I have a BAQ report in Epcior which will list all the records of a Sales order and in certain conditions will create a SFDC opportunity and set to closed won etc.this works fine but today OM had a longer than usual Sales order with 58 line items on i...
I have an Epicor BAQ report I use in Workato that gives me a list of all SKUs in an order and their shipping information99.9% of the time all the SKUs in an order will be on the same pricebook but on rare occasions 2 SKUs might on pricebook X and 1 S...
it seems like a simple upsert into the OrderItem or products object in sfdc but get the error message that doesn;t really give me a clue as to what might be wrong 28 Status code: JSON_PARSER_ERROR,29 Message: Cannot deserialize ins...
this is working great but now I'm curios if there is a way to see if there are any blanksif I do this and test [Value Step3}.pluck('PriceLstParts_SfPriceBookEntryId18Char_c')I get a list of tehse fields such as"A" "B" "C" but sometimes its "A" "B" ...
Thanks… I was going down that path till I learned that unlike opportunity products where you add the ProductIDFor Order Products you HAVE to add the PricebookEntryID so once I did that I’m golden…. Now I just need to make sure there aren’t orders wit...
this is cool... haven't played with Lists much in here.So I created a List and loaded it with the field from the datapil which runs the BAQ report.Do I need to create the list or is there a way to do these formulas directly from the data Pil; saving ...
before I got here for Parts/SKUs, Pricing records and Customer account etc someone was manually updating the SFDc 18 digit ID in Epicor so i have been using that for thsoe BUT I have to loop through and do testing for example someone in Epicor might ...
