Zero Balance A/P Invoice

Yahoo Archive
1
We do alot of Zero Balance P.O.'s for tracking our returns. This way
are shipping/receiving is able to receive them in and we have a easy way
of tracking. Our Vendor 99% of the time sends us a zero balance
invoice for that part also. In 3.0 we entered the invoice in. But
Tuesday we went to 4.0, now we get an error not allowed a zero balance?

Anyone have any suggestions?

TIA.
Dina
Vamco International, Inc.
2
Dina,

I don't think there is any financial function you can do in 4.0 with a zero
balance.

Eric

Continental Industries Inc. Maker of Solid State Relays.
5456 E. McDowell Rd.
Mesa, Az. 85215
(480)985-7800 Ext. 217


We do alot of Zero Balance P.O.'s for tracking our returns. This way
are shipping/receiving is able to receive them in and we have a easy way
of tracking. Our Vendor 99% of the time sends us a zero balance
invoice for that part also. In 3.0 we entered the invoice in. But
Tuesday we went to 4.0, now we get an error not allowed a zero balance?

Anyone have any suggestions?
3
Please say this isn't so. This is really disturbing news for us as we face
4.0 later this month. We treat customer furnished material as if it was
purchased, going thru all the same steps, which of course necessitates
creating a zero $ invoice to clear the receipt. Sounds like workaround
time.
ARGHHHH!
Deb @ Reeder & Kline Machine Company

RE:
I don't think there is any financial function you can do in 4.0 with a zero
balance.

Eric

We do alot of Zero Balance P.O.'s for tracking our returns. This way
are shipping/receiving is able to receive them in and we have a easy way
of tracking. Our Vendor 99% of the time sends us a zero balance
invoice for that part also. In 3.0 we entered the invoice in. But
Tuesday we went to 4.0, now we get an error not allowed a zero balance?

Anyone have any suggestions?
Dina





[Non-text portions of this message have been removed]
4
Does anyone know if you can create a zero dollar check? We track our
employee/salespeople commissions in AP and enter a credit memo in the amount
of the commissions paid through payroll and then do a zero dollar check to
remove the paid commissions and the offsetting credit.
5
Eric,

How abot A/R?

Eric Tolliver wrote:

> Dina,
>
> I don't think there is any financial function you can do in 4.0 with a zero
> balance.
>
> Eric
>
> Continental Industries Inc. Maker of Solid State Relays.
> 5456 E. McDowell Rd.
> Mesa, Az. 85215
> (480)985-7800 Ext. 217
>
> We do alot of Zero Balance P.O.'s for tracking our returns. This way
> are shipping/receiving is able to receive them in and we have a easy way
> of tracking. Our Vendor 99% of the time sends us a zero balance
> invoice for that part also. In 3.0 we entered the invoice in. But
> Tuesday we went to 4.0, now we get an error not allowed a zero balance?
>
> Anyone have any suggestions?
>
> ------------------------------------------------------------------------
> Find long lost high school friends:
> http://click.egroups.com/1/7080/13/_/411782/_/964102874/
> ------------------------------------------------------------------------
>
> We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)
6
Deb,

Yes, I tried everything I can think of. We also do the same thing for our customer who supply materials. (BTW - an Epicor Rep. Suggestion). I do not know away around this either. Any idea's??

Thanks,
Dina

"Wilmoth, Deb" wrote:

> Please say this isn't so. This is really disturbing news for us as we face
> 4.0 later this month. We treat customer furnished material as if it was
> purchased, going thru all the same steps, which of course necessitates
> creating a zero $ invoice to clear the receipt. Sounds like workaround
> time.
> ARGHHHH!
> Deb @ Reeder & Kline Machine Company
>
> RE:
> I don't think there is any financial function you can do in 4.0 with a zero
> balance.
>
> Eric
>
> We do alot of Zero Balance P.O.'s for tracking our returns. This way
> are shipping/receiving is able to receive them in and we have a easy way
> of tracking. Our Vendor 99% of the time sends us a zero balance
> invoice for that part also. In 3.0 we entered the invoice in. But
> Tuesday we went to 4.0, now we get an error not allowed a zero balance?
>
> Anyone have any suggestions?
> Dina
>
> [Non-text portions of this message have been removed]
>
>
7
Eric,

In A/R you are able to create a zero balance invoice.

Thanks,
Dina

Eric Tolliver wrote:

> Dina,
>
> I don't think there is any financial function you can do in 4.0 with a zero
> balance.
>
> Eric
>
> Continental Industries Inc. Maker of Solid State Relays.
> 5456 E. McDowell Rd.
> Mesa, Az. 85215
> (480)985-7800 Ext. 217
>
> We do alot of Zero Balance P.O.'s for tracking our returns. This way
> are shipping/receiving is able to receive them in and we have a easy way
> of tracking. Our Vendor 99% of the time sends us a zero balance
> invoice for that part also. In 3.0 we entered the invoice in. But
> Tuesday we went to 4.0, now we get an error not allowed a zero balance?
>
>
8
I haven't taken the time in the midst of our year end to experiment in our
test company - However, our Purchasing manager suggested resorting to .0001
PO's which rounds to $ in invoice format but she wasn't able to resurrect
our test company after a power failure on Wednesday. (Road construction
struck Indy again and someone managed to cut the main powerline to the area
resulting in no electricity for about two hours. I haven't heard that we
lost any data though! The last time there was a big problem with road
construction, a gas line was cut resulting in a very impressive explosion
which killed one woman, blew up some houses and melted others. We count
ourselves lucky having only minor computer inconveniences.)

Deb

Dina wrote:
Yes, I tried everything I can think of. We also do the same thing for our
customer who supply materials. (BTW - an Epicor Rep. Suggestion). I do not
know away around this either. Any idea's??


Deb wrote:
We treat customer furnished material as if it was purchased, going thru all
the same steps, which of course necessitates creating a zero $ invoice to
clear the receipt.


[Non-text portions of this message have been removed]
9
Deb,
"our Purchasing manager suggested resorting to .0001"

It only allows you to go to .01. So I believe you workaround will not work. I am testing the Payment Adjustment Entry now to see how that works. If I enter the Invoice at .01, then use payment adjustment. I am not sure how it will effect my g/l for inventory I
will let you know.

I did get a document # from Vantage for a fix. 3401MPS. Please respond to have this fixed hopefully in a patch and not in CAIRO.

Thanks,
Dina

P.S. I never thought I would be glad to live in Pittsburgh.
10
At 03:13 PM 7/20/2000 , you wrote:
>"our Purchasing manager suggested resorting to .0001"
> >>>>
>It only allows you to go to .01. So I believe you workaround will not
>work. I am

You can make the price/unit each, 100, or 1000. Try $0.001 per 1000.

-WC
11
We also do quite a bit of work using material consigned by our
customers. At present we do not 'receive' the customers material into
Vantage. We are looking for a process where we can have an audit
trail of what the customer sent along with our normal order process
that shows what went out. Is anyone using a process other than
creating and receiving a PO? The PO process sounds good, but it
requires many extra steps.

To top it off, at times we need to return some of the customer
consigned material, and we would like to have a packing slip to
accompany it and for our records. Again, has anyone developed a
process to support these requirements.

Thanks

Gordon Marble

--- In vantage@egroups.com, "Wilmoth, Deb" <Deb@r...> wrote:
> Please say this isn't so. This is really disturbing news for us as
we face
> 4.0 later this month. We treat customer furnished material as if
it was
> purchased, going thru all the same steps, which of course
necessitates
> creating a zero $ invoice to clear the receipt. Sounds like
workaround
> time.
> ARGHHHH!
> Deb @ Reeder & Kline Machine Company
>
> RE:
> I don't think there is any financial function you can do in 4.0
with a zero
> balance.
>
> Eric
>
> We do alot of Zero Balance P.O.'s for tracking our returns. This
way
> are shipping/receiving is able to receive them in and we have a
easy way
> of tracking. Our Vendor 99% of the time sends us a zero balance
> invoice for that part also. In 3.0 we entered the invoice in. But
> Tuesday we went to 4.0, now we get an error not allowed a zero
balance?
>
> Anyone have any suggestions?
> Dina
12
Wayne

> You can make the price/unit each, 100, or 1000. Try $0.001 per 1000.<

You are right for line detail, but you have to enter a Invoice Amount on the header screen, which will not let you enter .00001 or units of measure. So if you enter .0001 on the invoice line and .01 for invoice amount you end of with a variance of -.01 which I believe
is posted to g/l for a variance account.

I believe if you enter the .01 for invoice amount also for the line item. Then use payment adjustment Entry, this will work. I am still testing.

Dina


>
>
>
>
13
We just converted to 4.00.811. Is there a source that shows in which tables
obsolete fields have been transferred? For example, I have reports that
reference the old field PrimBin which WAS in the table PartWhse. Is the
PrimBin referenced someplace else now? How can I find that? Thank you.

Amy MacKay
Parkinson Machinery
14
>We just converted to 4.00.811. Is there a source that shows in which tables
>obsolete fields have been transferred? For example, I have reports that
>reference the old field PrimBin which WAS in the table PartWhse. Is the
>PrimBin referenced someplace else now? How can I find that? Thank you.
>
>Amy MacKay
>Parkinson Machinery

It is in the part plant table.

Anna Bookwalter
15
Good point. In the future we will add a comment to the db description of
obsolete fields indicating if they have been moved or what.
In 4.0 many fields moved from the Part to the PartPlant. In your case the
PrimBin moved to the PlantWhse.

-----Original Message-----
From: Amy Mackay [mailto:amackay@...]
Sent: Friday, July 21, 2000 5:45 AM
To: vantage@egroups.com
Subject: [Vantage] Primary Bin table?

We just converted to 4.00.811. Is there a source that shows in which tables
obsolete fields have been transferred? For example, I have reports that
reference the old field PrimBin which WAS in the table PartWhse. Is the
PrimBin referenced someplace else now? How can I find that? Thank you.

Amy MacKay
Parkinson Machinery




------------------------------------------------------------------------
Find long lost high school friends:
http://click.egroups.com/1/7080/13/_/411782/_/964185605/
------------------------------------------------------------------------

We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
16
There is a way to do this in 3.0, we are not on 4.0 yet so I'm not sure what is available. In 3.0 go to Start\Programs\Progress\Database Administration

Database\Connect - connect to your DB.
Database\Reports\Quick Field
Type "All" (without the quotes).
Check "Show Hidden"
Click "OK"
Click "Print"
Send Output to: Select "File"
Type in File Destination and Filename. ex. x:\dir\filename.txt

Open this file with Word or Wordpad.

Now you can search for fields or tables.


Todd Anderson wrote:

> Amy,
>
> No on the first question - you have to hunt.
> PrimBin is now in PlantWhse table. It was moved as part of the upgrades to
> correctly support multiple plants.
>
> Todd Anderson
>
> We just converted to 4.00.811. Is there a source that shows in which tables
> obsolete fields have been transferred? For example, I have reports that
> reference the old field PrimBin which WAS in the table PartWhse. Is the
> PrimBin referenced someplace else now? How can I find that? Thank you.
>
> Amy MacKay
> Parkinson Machinery
17
At 09:54 AM 7/21/2000 , you wrote:
>No on the first question - you have to hunt.
>PrimBin is now in PlantWhse table. It was moved as part of the upgrades to

Having a searchable copy of ALL the dictionaries is really handy for
finding stuff like this. You can run a Data Dictionary Report for all
tables, then print preview it. While you're still in the preview screen,
go to \VntgWork and grab a copy of the text file. Then you can open and
search it with word pad or your favorite text editor. I think someone
uploaded a PDF version of the same thing to EGroups, but I prefer plain
text anyways.

-Wayne
18
I have a couple of concerns with a PO process:
1) Do I have to create a P/N for every item that is received? We have
many parts and get new parts on a weekly basis and some items are a
one-time use. We are a service provider that turns part around in a
couple of days. At this time it does not make sense to add a new work-
around.
2) I believe I can receive an item against a PO without a P/N, but at
the time of receipt i will not have a job to receive it against. i do
not want the receipt to go against an expensed g/l. Where do your
receipts go if you are not using a P/N?
3) How do you receive items that you are not expecting?

Gordon Marble

--- In vantage@egroups.com, Rubberasc@a... wrote:
> We recieve customer consigned materials also, what we do is create
a single po and use it for a year. Simply add a release line to the
existing po.

Shirley Graver
Sys Admin
Rubber Associates
19
Is there any way to print a listing of all the reports in a report library?
Thanks.

Amy MacKay

-----Original Message-----
From: Wayne Cox [mailto:wmc@...]
Sent: Friday, July 21, 2000 10:47 AM
To: vantage@egroups.com
Subject: RE: [Vantage] Primary Bin table?


At 09:54 AM 7/21/2000 , you wrote:
>No on the first question - you have to hunt.
>PrimBin is now in PlantWhse table. It was moved as part of the upgrades to

Having a searchable copy of ALL the dictionaries is really handy for
finding stuff like this. You can run a Data Dictionary Report for all
tables, then print preview it. While you're still in the preview screen,
go to \VntgWork and grab a copy of the text file. Then you can open and
search it with word pad or your favorite text editor. I think someone
uploaded a PDF version of the same thing to EGroups, but I prefer plain
text anyways.

-Wayne


------------------------------------------------------------------------
Make new friends, find the old at Classmates.com:
http://click.egroups.com/1/7075/13/_/411782/_/964190984/
------------------------------------------------------------------------

We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
20
I hope it's still ok to post Vantage-related Job listings on this list. I
apoligize ahead of time if it's not. Thank you.

Amy MacKay

Engineering Aid

Manufacturer of capital equipment has immediate opening for an individual to
work as an Engineering Aid. Job will consist of data entry and management
in company-integrated software with opportunity for advancement. Background
in purchasing or drafting for general knowledge of mechanical parts is a
plus. Individual must be organized, able to work independently, and possess
good communication skills.

Submit resumes to:

Amy MacKay
Parkinson Machinery and Mfg Corp.
100 Goldstein Drive
Highland Industrial Park
Woonsocket, RI 02895
(Fax) 401-762-2295
E-mail: amackay@...