Interprise Suite Community / Interprise Suite Community Forums / Questions and Comments About Features, Functions and Workarounds / Supplier / Trying to Save/Post Supplier Bill / Latest Posts

RE: Trying to Save/Post Supplier Bill

NAYLARD — Fri, 29 May 2009 11:21:45 GMT

I had read that post earlier and updated the postbill procedure before asking my question. However it did not resolve our problem for this bill. Actually, i wish i had known that quite sooner since i have quite a few other bills that posted in which i will have to now adjust our journal. I assume it has something to do with our data/views not calculating correctly. Only if there was a tool to verify the integrity of the db and its procedures making sure they are correct.

Side note: i did have to rename/remove aliases from some of the item views because our data dictionary did not seem to like us adding custom fields to the item table. Views i never touched had fields labeled incorrectly. Was a bit bizarre.

RE: Trying to Save/Post Supplier Bill

BJ Dimes — Fri, 29 May 2009 09:40:49 GMT

Naylard,

I didnt know if you knew this but there is a problem with saving a supplier bill in V5.3.1. If you use any expense items (I'm assuming this is how you are entering in the Freight), you will see problems including duplicate entires inside the GL. Please review the following thread to fix this issue: http://www.interprisesuitecommunity.com/Topic108-18-1.aspx

Hopefully this will solve your problem. If not, let me know and I'll try and give you some ideas to try.

RE: Trying to Save/Post Supplier Bill

NAYLARD — Fri, 29 May 2009 09:08:06 GMT

We are running 5.3.1. We are posting inventory items with $1 freight. On the summary tab, it shows the following:

qty ordered qty received invoiced qty uninvoiced qty uninvoiced total
20 40 20 20 526.8
6 12 6 6 228
6 12 6 6 228

*uninvoiced total equals total for that bill + $1 for freight.

RE: Trying to Save/Post Supplier Bill

BJ Dimes — Fri, 29 May 2009 08:53:44 GMT

Naylard,

What version of IS are you running? What exactly are you trying to bill? Simply an Expense Item (Rent/Utilities/etc/)? Inventory Items? Inventory and Expense Items (Freight, etc.)?

Sorry for the questions. Just need a little more information to see if I can figure out what is going on.

Thanks,

Trying to Save/Post Supplier Bill

NAYLARD — Thu, 28 May 2009 17:09:58 GMT

I am getting this message for a bill i am trying to save. Everything matches and i cannot seem to figure out where the problem lies.

Message:

Posting returned the following message(s):
Debit and credit amounts not balanced

Any thoughts to where can I adjust or see what amounts are trying to balance

Thx