[iecpradeep]

is it possible to bill a PO via CSV import?

if yes then if i bill the PO through CSV import then PO status bill change from pending biling to billed .

i am having Purchase orders which are having more then one reciept. i mean purchase order in recieved in parts . user did not bill the order at the time of when they recieved the order partially. now i want to bill the purchase order reciept-wise.

For Example there is one PO- PO10000000415

having to reciepts- IR10000002091,IR10000002162

now i want to make 2 bills for the above order po one for first item recipet and second for other item reciept but when i click on bill purchase order it picked all the quantity i have recieved but i want that it should pick the quantity …item reciept wise.

How can i do this..
This is a cached copy. Click here to see the original post.

[Olivier Gagnon NC]

RE: is it possible to bill a PO via CSV import?

It is not possible to Bill using CSV.

To create a Bill containing only what's on a given Receipt, you must press the Bill button from the Item Receipt rather than the PO.

There is no quick way to automate this unless you use a script.

[iecpradeep]

RE: is it possible to bill a PO via CSV import?

There is no Bill Button on item reciept.

what should i need to do to get the bill button on item reciept.

If i am editing the item reciept and clicking save and bill it's picking items from PO not item reciept

[jguarico]

Hello Pradeep,

We actually do not have a way of doing a CSV import of bills that will be linked to a purchase order. This is still an enhancement request, Enhancement #173842 – CSV Imports: Ability to link Vendor Bills to Purchase Order Transactions

With your second question, the only way for you to create a bill for each item receipt is to remove one of the item receipts, then, click on Edit on the other existing item receipt click on Save and Bill instead of save (click on the arrow pointing downward to see the option to Save and Bill). This will let you bill the item receipt that you only have. Then after that, receive again the quantity left in the purchase order then click on Save and Bill again.

One workaround also is to just edit the quantity in the bill, then save it. Then create another bill from the purchase order.

I hope this helps. Thank you.

---

mrdennisclark replied on 12/15/2016, 12:01 PM: what this ever done? Enhancement #173842 – CSV Imports: Ability to link Vendor Bills to Purchase Order Transactions

[iecpradeep]

RE: is it possible to bill a PO via CSV import?

it's difficult because we are having so many items into PO/item reciept(some case we haing upto 200-300 item on PO) and checking one by one

include lot of extra work.

I am looking for a work around to bill reciept instead of PO

Is this possible???

[jpberlips]

Hi,

I have just discovered this problem as well.

Would it be possible to do the "Save and Bill" using a suitescript and the using another to merge the multiple vendor bills to one bill after all receipts has been billed?

Background: We receive against on one PO over one, two or more month but are billed end of each month. Thus, I need to only bill the receipts that were received during one month (the previous)

[iecpradeep]

RE: is it possible to bill a PO via CSV import?

Hello Sr,

what's that code?

can you share with me?

Plz help!!!

[jpberlips]

We have not written any script for that yet. Still pending the question if it is possible.

JP

[JimJenkins]

Did you ever get a script written for this?

I can get the button on the screen and run a script, but I am having difficulty figuring out how to bill from script.

Any help is always appreciated. Thanks.

[mgoodman]

RE: is it possible to bill a PO via CSV import?

Originally posted by JimJenkins

View Post

I can get the button on the screen and run a script, but I am having difficulty figuring out how to bill from script.

In scripting, when you want to emulate a button press that transforms a transaction into another one (ex: Purchase Order to Item Receipt, Purchase Order to Bill, Sales Order to Invoice, etc.), it is normally done using nlapiTransformRecord(). Check out the "SuiteScript API" in the Help Center for full details, including supported transformations.

Note that Item Receipt to Bill is not a supported transformation. You'll have to do Purchase Order to Bill and programatically determine what needs to be billed.

[Author]

Posts