SOP Packing slip with SOP Invoice generated from Returns Managemen
I have created a SOP invoice by closing an RMA in Returns Management. When I
print this invoice, I would also like to print the SOP packing slip.
I am able to check the Packing Slip box on the the Sales Document Print
Options window and I even get a Report Destination window for the Packing
Slip, but nothing prints.
If I generate the SOP invoice from scratch or by transferring an SOP order
to an invoice, the packing slip prints fine.
What might I be doing incorrectly, or can you not print an SOP packing slip
for an SOP invoice created in Returns Management?
I determined that the probe...POP-SOP Link #2
Is there any way to create one PO from multiple SOP orders with the POP/SOP
Link? Or, is it only one PO per each order?
Yes, you can add one PO to multiple SOP orders - you can enter the link
either from the SOP side by clicking on the little icon above the quantity
ordered, or from the PO side by clicking on that same icon above the
quantity ordered. You have to make sure the PO has Allow Sales Documents
Hope that helps.
"Elaine" <Elaine@discussions.microsoft.com> wrote in message
news:DCCC1906-ED2B-4FCB-A6FC...encrypt data in registry
Sorry, I realize this is not an MFC question but hopefully you will
I would like to encrypt some data in the registry. At least I think
I'd like to do that. :-)
I'm storing a secret key. I don't want to depend on access rights
because, well they seem complicated and also I don't want a registry
backup to expose the key.
I want to avoid storing a separate key, used to encrypt the registry
data, because that seems obviously not helpful. That key would
necessarily have to be on the machine and therefore doesn't offer a
lot of protection. Still, that might b...Excel data labels from other data
I have plotted some data on a chart and it looks great. However I want
to put a data label on each point that is part of another row like so:
Date 3/12/03 5/20/03
Bldgheight 25 26
BldgName HDQ1 HDQ2
The graph is made up of date on the x-axis and height on the y-axis.
However when the points are displayed I want the data label to display
the Name row. is that possible.
have a look at the following add-ins which will do this
for you as
Excel does not support this automatically
http://www.appspro.co...moving data to outlook
I have a company roster that has names, numbers and email addresses that i
would like to put into my contacts in Microsoft outlook, can anyone help me ?
"newbe" <email@example.com> wrote in message
>I have a company roster that has names, numbers and email addresses that i
> would like to put into my contacts in Microsoft outlook, can anyone help
> me ?
Firstly, export a contact from Outlook to Excel and compare the data. Format
the Excel spreadsheet to equal the e...Copy data of some fields on a form to the next record
I have a form used to enter data on a record in which 7 of the fields will
contain the exact same data for several sebsequent records. Instead of
having to re-enter repetative data for several sebsequent records, I need a
checkbox (or some indicator) that would set a control that when checked, it
would tell the database that it should carry the data in a certain set of
fields (the 7) to the next record. For instance, when you order an item
online using a credit card and if you check the box the delivery address
information you just entered will repeat or copy to the billing address
f...What does Ship Complete in SOP do?
What does Ship Complete do in SOP? We are allocating by line and are using a
separate fulfillment process. We are not using Advanced distribution and/or
"Ship Complete Documents" is an option on the customer card selected if the
customer does not allow partial product shipments. Partial line item
quantities won’t be transferred in Sales Order Processing if the customer
doesn’t accept partial shipments. For example, if you have an order for 10
and you have only fulfilled 8, you will not be able to transfer it to an
invoice until all 10 items are fulfilled...Looking for a method to print only those worksheets that the user has entered data into
I have a workbook that has 7 worksheets un-hidden. Of those, each has a limited number of cells that are un-protected. Each sheet prints to a single page. The user can enter data on one, some or all of the sheets. Is there a short-cut method that would allow the user to (at a single click) print all of the sheets that have user-input data and not any of those that are left 'blank'
not possible without VBA
"rpw" <firstname.lastname@example.org> schrieb im Newsbeitrag
news:732719CD-1559-4CD1-B0...SOP Blank Invoice History
I am amending this report. I am happy with the report footer with the Net,
Tax, Document total fields. I note where these come from and the
'Funtional/Originating' calculation to force a functional currency/
originating currency field (per the option picked when the report is
written). However, how do I 'emulate' this at the line item level. I see no
F/O calculated fields (other than extended cost) - which fields should I use
for my own F/O calculation i.e. which field are the 'net amount', 'tax
amount' and 'gross amount' in originationg and f...How to show data between two dates?
I have a list of tenants and the dates they moved in and out of their flats.
I need to show which weeks within a specific period that the flats were
filled - either by showing the tenants intials or a tick.
A B C D E
F G H
Unit No Client Start End 04-01 11-01 18-01 25-01
1 JB 23-11 06-02 JB
2 GK 05-01 GK GK GK GK
3 LB 01-12 28-02 LB LB LB LB
Does anybody know how is best to do this? We've tried using an IF formula
but it doesn't work if their is a start and end date.
...Auto Allocate/Fulfill SOP when items are in multiple bins
GP Sales Order Processing requires additional data entry whenever a sales
order quantity ordered exceeds the quantity avaiable in the Item Site Default
Bin>Sales Order Fulfillment Bin. The allocation/fulfillment exception report
will list the documents and items & instructions that "Additional bin
selections are required for item number XXXXXX.
We require a process to automatically allocate & fulfill by Document/Batch
based on the quantity available in all bins for that item.
Does anyone have a solution?
Created a solution - in SOP & Inventory>Auto ...Breaking up data
I have, at this time, a simple table containing data in ONE field. The
next line is a sample of this data.
I would like to split this data into two fields ..... the first one
containing CLASS up to and containing the colon and the second
containing the remainder. While I'm sure this has been addressed
before I can't seem to come up with the correct input for the search
criteria in the knowledgebase. Any help appreciated.
On Sat, 20 Oct 2007 14:29:44 -0700, TeeSee wrote:
> I have, at this time, a simple table containing data in ONE field. The
> n...Link Data to Shapes not Displayed under Data Menu
I am trying to follow along with the practice part of the Visio 2007 How to
link data to diagrams training session. However, when I go under the data
menu, the 'Link Data to Shapes' is not listed. Any ideas?
the data linking feature is in visio professional and not in visio standard,
what version do you have?
"KT" <KT@discussions.microsoft.com> wrote in message
> I am trying to follow along with the practice part of the Visio 2007 How
> link data to diagrams training sessio...Duplicating Entries
When I am using the Control key to click on several entries to delete from my
Inbox, it seems that if I click additional entries too quickly, the entries I
have already selected are copied and added to the Inbox. It is very annoying.
Is there a way to disable this?
"There are seldom technological solutions to behavioral problems" - Internet
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, Martin asked:...Converting data list into spreadsheet
How do I convert a long 1000+ list of numbers into a
"GN" <email@example.com> wrote in message
> How do I convert a long 1000+ list of numbers into a
How is the info laid out?
What's the format of the file? ASCII, comma delimited, tab
More info would be best, however you should be able to
open the list in Excel. The Import Wizard should start
automatically and walk you through the import.
G...Customization in SOP
I want to Pick the Price from the billing master table
(New table) for the field '(L) Unit Price' in SOP Entry screen.In that
table for every item price is stored in Lot level. After picking up the
tax and further all should calcullate on the basis of (qty * '(L) Unit
How to achieve this,help is appericiated.
...Pivot table for two different data variables
I have the following table
Name type Cost overhead
amy C1 23 12
bob C2 129 17
cat C2 36 45
doo C2 100 32
I owuld like to create a pivot table that looks similar to:
the standard pivot table. (Please ignore type for now.)
name Data Total
amy Sum of overhead 200
Sum of cost 12
bob Sum of overhead 130
Sum of cost 23
cat Sum of overhead 90
Sum of cost 19
doo Sum of overhead 87
Sum of cost 34
Total Sum of overhead 507
Total Sum of cost 88
But with overall total (overhead + cost) for ...Displaying temparature data in degrees
How we display temparature information in degrees in an
Thanks for helping.
"Jijy" <firstname.lastname@example.org> wrote in message
> How we display temparature information in degrees in an
> excel spreadsheet?
> Thanks for helping.
Format the cell with a custom format. Make this format a number with as many
decimal places as you want followed by the degree symbol. This is 0176 in
the standard Arial font. So in the custom format window, you would type 0.0
(if you want one decimal place), then hold down AL...Great Plains SOP Table Date Fields
I looking for clarification on what DOCDATE and ORDRDATE are in the SOP
tables. I believe that DOCDATE is the date the line was entered and that the
ORDRDATE is the date that the date that the Order goes into effect. Could
anyone clarify this for me?
Go to the SDK and look at SOPTRX.RTF. It is the Sales Order Transaction flow
by table and field.
"Chris Hornung" wrote:
> I looking for clarification on what DOCDATE and ORDRDATE are in the SOP
> tables. I believe that DOCDATE is the date the line was entered and that the
> ORDRDATE is the date that the date that the...Macro SOP
I recorded a macro in SOP using GP 9 and trying to edit it with
microsoft word, How can I achieve to have it insert multiple item rows
in a single SOP Number?
You will need to record entering more than one line to see how the code behaves. As a macro must have the correct number of lines
to match the data, you might have to write some conditional code on the Word document using the IF field so you can make a section
appear or disappear based on the lines...how do I keep my data series colour when I refresh a pivot chart
I changed the colours on the data series on my pivot chart but when I
refreshed the data it switched the colours back to the defaults. How can I
Loss of formatting is a know bug.
> I changed the colours on the data series on my pivot chart but when I
> refreshed the data it switched the colours back to the defaults. How can I
> stop this?
Andy Pope, Microsoft MVP - Excel
...Ability to copy SOP Lines regardless of the price level on item.
We would like to have the ablitiy to copy SOP lines using the copier series
even if the price level does not exist for the item. For example your target
document has a default price level of "Retail", but the item that you are
trying to copy is not setup for that price level. Currently you are not able
to copy the items like this.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow thi...IM SOP (Invoice) Document Number
I am bringing invoice information from another system into GP via integration
manager. all works well with the exception of the Document Number/Invoice
Number; I am using default; which creates a new number for each invoice item.
does anyone have a vbscript that can be used to get the next invoice number
for a client and use that number for all items coming in for that client
during the integration. there would be multiple invoice items per client and
multiple clients per integration. can anyone point me in the right direction
or have a script(s) to handle this. thanks
Do you have eCo...Help with data points in line graph in Chart function in Excel.
I added data to an existing line graph and the data points do not align
properly with the values on the Y axis. For example, a data point valued at
119 lines up between 400 and 800 on the Y axis. I know there's a way to fix
this, but just can't find it. Thanks!
...C# for SQL Data Transfer
This is really more of an SQL question but I'm doing the client-side
coding in C# so I figured it would make sense to post it here.
I'd like to export some portion of data from an SQL database to a
file, then import that data to a different database which has the same
structure. I've googled high and low and come up with a bunch of
different options, all of which seem to be more complicated than I was
hoping this would be.
The most common solution seems to be exporting to XML (easy) and then
using either an updategram or diffgram to import the data (never used